Re: Restoring a database from a file system snapshot

From: "postgres Emanuel CALVO FRANCO" <postgres(dot)arg(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Restoring a database from a file system snapshot
Date: 2008-08-27 19:32:45
Message-ID: f205bb120808271232x4ab98388i2774a92c433ec7bd@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sorry Alvaro, i sent to you the message ;P

Is the same way (from snapshot) that use Mysql on ZFS.
IF you don't change anything in the database, why it don't works?
Then you restart the service with the same path.
The problem it will be that you need to stop postgres BEFORE snapshot.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message btober 2008-08-27 19:42:42 pg_dumpall problem when roles have default schemas
Previous Message Jeff Davis 2008-08-27 19:26:42 strange explain analyze output