Re: Independent backups of subdatabases - Mailing list pgsql-general

From John R Pierce
Subject Re: Independent backups of subdatabases
Date
Msg-id 50F6379C.2090002@hogranch.com
Whole thread Raw
In response to Independent backups of subdatabases  (Robert James <srobertjames@gmail.com>)
Responses Re: Independent backups of subdatabases  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
On 1/15/2013 9:02 PM, Robert James wrote:
> I would do this as actual databases, but Postgres doesn't allow JOINs
> and FKs between different databases.  Can I use schema for the above?
> How? How do I backup and restore schema independently?

pg_dump --schema= ...

and drop schema, create schema prior to a restore of a given schema


pgsql-general by date:

Previous
From: Robert James
Date:
Subject: Independent backups of subdatabases
Next
From: Tatsuo Ishii
Date:
Subject: Re: [pgpool-general: 1315] Re: Database connections seemingly hanging