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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Bobby Gontarski > Sent: Sunday, September 24, 2006 5:21 PM > To: pgsql-general@postgresql.org > 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
