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

From Jim Nasby
Subject Re: copy db1 to db2
Date
Msg-id 9116C2CC-15C7-4B1C-BB43-EA1C147393A8@decibel.org
Whole thread Raw
In response to Re: copy db1 to db2  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-general
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)



pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: postgresql rising
Next
From: Jim Nasby
Date:
Subject: Re: pl/perl autonomous transactions question