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

  • Andreas Kretschmer at Sep 27, 2006 at 12:57 pm

    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
  • Ilan Volow at Sep 27, 2006 at 1:20 pm
    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

Related Discussions

Discussion Navigation
viewthread | post
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