Re: Replacing data

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Replacing data
Date: 2006-06-15 12:03:07
Message-ID: 5.2.1.1.0.20060615075544.025121d0@pop6.sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

At 07:22 AM 6/15/06, chelsea boot wrote:
>I want to replace all the data in a database with an earlier backup I
>took. I have a plain sql-script dump (backup.sql) and am using the
>following command to replace the current data:
>
>psql -U postgres dbname < backup.sql
>
>However, the command seems to append the data to the database so that I
>have the old data and any new data added since the backup was taken. How
>can I replace all the data so that my database only contains data from the
>backup? Maybe I'm using the wrong backup and restore method?

Looks like you missed -c option of pg_dump during backup. For this time
only, you could use '-c -s' options to drop/create all objects, then
restore the way you did above.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Alex du Plessis 2006-06-15 12:51:32 functions returning sets
Previous Message Aarni Ruuhimäki 2006-06-15 11:43:01 Re: Replacing data