Postgres Pro
Downloads
Home   >   mailing lists

Re: Moving Database Directory - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Moving Database Directory
Date
Msg-id Pine.LNX.4.44.0311132305410.17499-100000@peter.localdomain
Whole thread Raw
In response to Moving Database Directory  (Greg Spiegelberg <gspiegelberg@cranel.com>)
List pgsql-admin
Tree view 
Greg Spiegelberg writes:

> Is there a way to "deport" a database on systemA and "import" it on
> systemB without having to do a pg_dump/pg_restore?  Basically ask
> the database on systemA to stop using dbA1 under /data/dbA1 then tell
> systemB to use the database already at /data/dbA1.

Not possible.  Either the whole cluster or nothing.

--
Peter Eisentraut   peter_e@gmx.net

pgsql-admin by date:

Previous
From: ow
Date:
Subject: pg_restore and FK constraints with large dbs
Next
From: Peter Eisentraut
Date:
Subject: Re: pg_restore and FK constraints with large dbs