What kind of errors? Just saying "i got some errors" isn't very helpfull for us to be able to help you properly ;) So, what exact error messages you get when trying to restore the database? -- Matthias > -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of > Bobby Gontarski > Sent: Sunday, September 24, 2006 5:21 PM > To: pgsql-general@xxxxxxxxxxxxxx > Subject: [GENERAL] copy db1 to db2 > > > 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... > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Have you searched our list archives? > http://archives.postgresql.org
