Thread: Backup & Restore
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
am Wed, dem 27.09.2006, um 9:13:54 -0300 mailte Felipe Giotto folgendes: > 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 Perhaps you should use pg_dumpall for all databases, not only a specific database. > remember the parameters right now), but pg_restore always returns an > error about primary key violations. Can anybody tell me two commands to Which version? Prior versions of pg_dump may include errors. > backup and restore my databases without these key violation problems? Can you give us more information about: - version - parameters - exact error message? Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
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