How to remove the current database and populate the database with new data?

From: "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: How to remove the current database and populate the database with new data?
Date: 2010-06-03 23:05:14
Message-ID: FA20D4C4FEBFD148B1C0CB09913825FC04589DD6BF@XCH-SW-06V.sw.nos.boeing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I've some test data in a database and would like to delete that database and clean everything that is associated with that database. Then I'd like to populate the same database with different data.
My plan is to:
(1) Remove the /usr/local/pgsql/data directory
(2) psql -e mydatabase -f /tmp/indumpfile.txt & > /tmp/outdumpfile.txt (/tmp/indumpfile.txt has all the sql statements to restore the database)
(3) Restart the postgres server

Not sure if I need to run the VACCUM command, because I know Postgres 8.3.8 has the auto-vacuum daemon on to perform VACCUMs when it's necessary. Did I miss any other steps for cleaning up?

Please advise.

Thanks
Mary

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2010-06-03 23:09:25 Re: How to remove the current database and populate the database with new data?
Previous Message Vick Khera 2010-06-03 20:33:46 Re: pgbouncer