Postgres Pro
Downloads
Home   >   mailing lists

Re: restoring a database from a file copy - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: restoring a database from a file copy
Date
Msg-id 20040620151209.GA12443@wolff.to
Whole thread Raw
In response to restoring a database from a file copy  (Chris Fjell <cfjell@bcgsc.ca>)
Responses Problems restoring a DB with oids
List pgsql-admin
Tree view 
On Fri, Jun 18, 2004 at 16:42:18 -0700,
  Chris Fjell <cfjell@bcgsc.ca> wrote:
> Can a database system be restored just from the data under the
> installation directory?

Only if the postmaster has been shut down. For live backups you should
be using pg_dumpall.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Debugging SQL Statements from *any* client(s)
Next
From: "Frederic Medery"
Date:
Subject: Database Schemas generator