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

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 3 | next ›
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedSep 27, '06 at 12:34p
activeSep 27, '06 at 1:20p
posts3
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase