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.