| From: | Jim Nasby <decibel(at)decibel(dot)org> |
|---|---|
| To: | Bill Moran <wmoran(at)collaborativefusion(dot)com> |
| Cc: | "Bobby Gontarski" <Gontarski(at)seznam(dot)cz>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: copy db1 to db2 |
| Date: | 2006-09-27 05:24:32 |
| Message-ID: | 9116C2CC-15C7-4B1C-BB43-EA1C147393A8@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sep 25, 2006, at 9:49 AM, Bill Moran wrote:
> 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.
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(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2006-09-27 05:32:08 | Re: pl/perl autonomous transactions question |
| Previous Message | Najib Abi Fadel | 2006-09-27 05:22:09 | Re: What is the Best Postgresql Load Balancing Solution available ? |