| From: | chelsea boot <scx6148(at)yahoo(dot)co(dot)uk> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Replacing data |
| Date: | 2006-06-15 11:22:49 |
| Message-ID: | 20060615112250.68776.qmail@web86802.mail.ukl.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi
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?
Thanks
Send instant messages to your online friends http://uk.messenger.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aarni Ruuhimäki | 2006-06-15 11:43:01 | Re: Replacing data |
| Previous Message | David Fetter | 2006-06-15 00:58:09 | Re: Can PostgreSQL 8.x Return Multiple "Result Sets" ? |