Postgres Pro
Downloads
Home   >   mailing lists

Re: copy db1 to db2 - Mailing list pgsql-general

From Bill Moran
Subject Re: copy db1 to db2
Date
Msg-id 20060925094929.89a5cedd.wmoran@collaborativefusion.com
Whole thread Raw
In response to copy db1 to db2  (Bobby Gontarski <Gontarski@seznam.cz>)
Responses Re: copy db1 to db2  (Jim Nasby <decibel@decibel.org>)
List pgsql-general
Tree view 
In response to "Bobby Gontarski" <Gontarski@seznam.cz>:

> Basically I need to copy db1 to db2 which I create manually. How do I
> do that, I tried pg_dump pg_restore but I get some errors with foreign
> key restraint...

You can use create database with db1 as the template.  See the docs for
details.

--
Bill Moran
Collaborative Fusion Inc.

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: in failed sql transaction
Next
From: Scott Marlowe
Date:
Subject: Re: in failed sql transaction