Re: [GENERAL] Independent backups of subdatabases

2013-01-16 Thread Adrian Klaver
On 01/15/2013 09:16 PM, John R Pierce wrote: 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 --sc

Re: [GENERAL] Independent backups of subdatabases

2013-01-15 Thread John R Pierce
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 prio