Postgres Pro
Downloads
Home   >   mailing lists

Thread: copy db1 to db2

copy db1 to db2

From
Bobby Gontarski
Date:
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
someerrors with foreign key restraint...

Re: copy db1 to db2

From
Bill Moran
Date:
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.

Re: copy db1 to db2

From
Jim Nasby
Date:
On Sep 25, 2006, at 9:49 AM, Bill Moran wrote:
> 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.

But if you're getting foreign key constraint errors, you probably
have some other issue that you should figure out.

What version is this anyway?
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)