Skip site navigation (1) Skip section navigation (2)

Re: Backup & Restore

From: Ilan Volow <listboy(at)clarux(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Backup & Restore
Date: 2006-09-27 13:13:21
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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


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

In response to

pgsql-novice by date

Next:From: Michael FuhrDate: 2006-09-27 13:32:33
Subject: Re: pass date type data to PQexecparams
Previous:From: A. KretschmerDate: 2006-09-27 12:57:05
Subject: Re: Backup & Restore

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group