> 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
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.
In response to
pgsql-general by date
|Next:||From: Alvaro Herrera||Date: 2008-08-27 18:37:36|
|Subject: Re: Restoring a database from a file system snapshot|
|Previous:||From: William Garrison||Date: 2008-08-27 17:54:11|
|Subject: Restoring a database from a file system snapshot|