Postgres Pro
Downloads
Home   >   mailing lists

How to remove the current database and populate the database with new data? - Mailing list pgsql-general

From Wang, Mary Y
Subject How to remove the current database and populate the database with new data?
Date
Msg-id FA20D4C4FEBFD148B1C0CB09913825FC04589DD6BF@XCH-SW-06V.sw.nos.boeing.com
Whole thread Raw
Responses Re: How to remove the current database and populate the database with new data?  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: How to remove the current database and populate the database with new data?  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: How to remove the current database and populate thedatabase with new data?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Tree view 
Hi,

I've some test data in a database and would like to delete that database and clean everything that is associated with
thatdatabase.  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
torestore 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
VACCUMswhen it's necessary.  Did I miss any other steps for cleaning up? 

Please advise.

Thanks
Mary

pgsql-general by date:

Previous
From: Marc Bevand
Date:
Subject: Re: PostgreSQL and NeXpose Rapid 7 Vulnerbility scanning software
Next
From: "Joshua D. Drake"
Date:
Subject: Re: How to remove the current database and populate the database with new data?