Backup setup

by gabor@[EMAIL PROTECTED] ("Gabor Siklos") Apr 23, 2008 at 11:14 AM

This is a multipart message in MIME format.

------=_NextPart_000_009C_01C8A533.361A2F60
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

I need to back up our database off-site for disaster recovery. If I just
back up the entire database data directory (i.e. /var/lib/pgsql/data) will
I
be able to restore from there? Or should I instead just dump the data,
using
pg_dump, and back up the dump?
The advantage of the first method would be that I would not have to wait
for
pg_dump (it takes quite long on our 60G+ database) and would just be able
to
configure the backup agent to monitor the data directory and do
differential
backups of the files there every hour or so. 
Your suggestions are much appreciated!
-Gabor


------=_NextPart_000_009C_01C8A533.361A2F60
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
08.00.0681.000">
<TITLE>Backup setup</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT FACE=3D"Calibri">I need to back =
up our database off-site for disaster recovery. If I just back up the =
entire database data directory (i.e. /var/lib/pgsql/data) will I be able =
to restore from there? Or should I instead just dump the data, using =
pg_dump, and back up the dump?</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT FACE=3D"Calibri">The advantage =
of the</FONT></SPAN><SPAN LANG=3D"en-us"> <FONT FACE=3D"Calibri">first =
method would be that I would not have to wait for pg_dump (it takes =
quite long on our 60G+ database) and would just be able to configure the =
backup agent to monitor the data directory and do</FONT></SPAN><SPAN =
LANG=3D"en-us"> <FONT FACE=3D"Calibri">differential backups of the files =
there every hour or so.</FONT></SPAN><SPAN LANG=3D"en-us"> </SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">Your</FONT></SPAN><SPAN LANG=3D"en-us"> <FONT =
FACE=3D"Calibri">suggestions are much appreciated!</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">-Gabor</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN></P>

</BODY>
</HTML>
------=_NextPart_000_009C_01C8A533.361A2F60--

6 Posts in Topic:

Backup setup

gabor@[EMAIL PROTECTED]

2008-04-23 11:14:32

Re: Backup setup

terry@[EMAIL PROTECTED]

2008-04-23 11:22:42

Re: Backup setup

tometzky@[EMAIL PROTECTED

2008-04-24 10:11:54

Re: Backup setup

tgl@[EMAIL PROTECTED] (T