Re: Restoring a database from a file system snapshot

From: Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com>
To: Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Restoring a database from a file system snapshot
Date: 2008-08-27 18:08:23
Message-ID: 1219860503.22189.6.camel@jmf-ubuntu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-08-27 18:37:36 Re: Restoring a database from a file system snapshot
Previous Message William Garrison 2008-08-27 17:54:11 Restoring a database from a file system snapshot