Re: Restoring a database from a file system snapshot - Mailing list pgsql-general

From Joao Ferreira gmail
Subject Re: Restoring a database from a file system snapshot
Date
Msg-id 1219860503.22189.6.camel@jmf-ubuntu
Whole thread Raw
In response to Restoring a database from a file system snapshot  (William Garrison <postgres@mobydisk.com>)
List pgsql-general
> Any suggestions?  Is my procedure correct?  Would I need to also copy
> the transaction logs or something like that?

the 'by the book' procedure for this operation is to use

pg_dumpall ......... > dump_file.sql

and later

psql -f dump_file.sql postgres



pg_dumpall gives you a transaction aware dump.

I'm not sure how you'dd do about that old snapshot, sorry.

joao


>


pgsql-general by date:

Previous
From: William Garrison
Date:
Subject: Restoring a database from a file system snapshot
Next
From: Alvaro Herrera
Date:
Subject: Re: Restoring a database from a file system snapshot