Backup & Restore

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

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