Thread: backup

backup

From
"dubois"
Date:
  Hi!

  I want to make a backup copy of a
database...
What I have to do?

  Do I have just to copy the directory
at

/var/lib/pgsql/base ?

  And to recover the database, I just
have
to unpack it again at

/var/lib/pgsql/base..

  Is that right?

  Thanks for any help...

  Regards,

  Andre'.


-----------------------
Andr� Rauber Du Bois
M.s.C. student at PPGC/UFRGS
dubois@inf.ufrgs.br


__________________________________________________________________________
Compras com facilidade e seguran�a?
ShoppingBOL
http://shopping.bol.com.br



Re: backup

From
Tom Lane
Date:
"dubois"<dubois@bol.com.br> writes:
>   I want to make a backup copy of a
> database...
> What I have to do?

pg_dumpall is the recommended answer.

>   Do I have just to copy the directory
> at
> /var/lib/pgsql/base ?

This is NOT sufficient.

Copying the entire $PGDATA directory (not only the base/ subdirectory)
is sufficient, if and only if the database is completely idle while you
do it --- I'd recommend stopping the postmaster to be sure.  Otherwise
you will get inconsistent files.  In particular, you WILL have problems
if $PGDATA/pg_log is out of sync with any table data file.

            regards, tom lane

Re: backup

From
"Anthony E . Greene"
Date:
On Mon, 08 Jan 2001 10:38:13 Tom Lane wrote:
>Copying the entire $PGDATA directory (not only the base/ subdirectory)
>is sufficient, if and only if the database is completely idle while you
>do it --- I'd recommend stopping the postmaster to be sure.  Otherwise
>you will get inconsistent files.  In particular, you WILL have problems
>if $PGDATA/pg_log is out of sync with any table data file.

You will also need to insure that the version of PostgreSQL used in the
recovery process is that same as that used before the failure. The binary
files are not completely portable across versions.

--
Anthony E. Greene <agreene@pobox.com> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
Chat:  AOL/Yahoo: TonyG05    ICQ: 91183266
Linux. The choice of a GNU Generation. <http://www.linux.org/>