On Thu, 2010-06-03 at 16:05 -0700, Wang, Mary Y wrote: > 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?
How about: psql -U postgres template1 -c "drop database <foo>"; psql -U postgres <foo> < inputfile.txt psql -U postgres <foo> -c "ANALYZE VERBOSE" What you have above won't work anyway as you need to stop postgres, initdb, recreate your users etc... Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
