Re: copy db1 to db2

From: Bill Moran <wmoran(at)collaborativefusion(dot)com>
To: "Bobby Gontarski" <Gontarski(at)seznam(dot)cz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: copy db1 to db2
Date: 2006-09-25 13:49:29
Message-ID: 20060925094929.89a5cedd.wmoran@collaborativefusion.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In response to "Bobby Gontarski" <Gontarski(at)seznam(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben Trewern 2006-09-25 14:04:04 Re: What is the Best Postgresql Load Balancing Solution available ?
Previous Message Karsten Hilbert 2006-09-25 13:09:34 Re: in failed sql transaction