My usual way of getting around this problem involves doing a pg_dump of the database, deleting the database, re-creating the database, and then repopulating it. For example, if there was a database named bunny, I'd do the following:
dropdb bunny
createdb bunny
psql bunny < bunny_backup_dump
--Ilan
On Sep 27, 2006, at 8:13 AM, Felipe Giotto wrote:
Hi!
I know this is a extremely novice question :D, but I'm trying to use a simple command to backup an entire database to a file, and then restore the entire database from the file, overwriting all the previously data stored on the old database. I tried pg_dump and pg_restore (i can't remember the parameters right now), but pg_restore always returns an error about primary key violations. Can anybody tell me two commands to backup and restore my databases without these key violation problems?
Thanks for the help!
Felipe Giotto ;-)
PS: Sorry for my poor english!! :D
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster