Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group