Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: copy db1 to db2
- 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: Wed, 27 Sep 2006 01:24:32 -0400
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 Ido that, I tried pg_dump pg_restore but I get some errors with foreignkey restraint...You can use create database with db1 as the template. See the docs fordetails.
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)
- References:
- copy db1 to db2
- From: Bobby Gontarski
- Re: copy db1 to db2
- From: Bill Moran
- copy db1 to db2
- Prev by Date: Re: What is the Best Postgresql Load Balancing Solution available ?
- Next by Date: Re: pl/perl autonomous transactions question
- Previous by thread: Re: copy db1 to db2
- Next by thread: Re: copy db1 to db2
- Indexes: