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.
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 |