Postgres Pro
Downloads
Home   >   mailing lists

Need to Reload a Dump File - Need to Delete the PGDATA directory Again? - Mailing list pgsql-general

From Wang, Mary Y
Subject Need to Reload a Dump File - Need to Delete the PGDATA directory Again?
Date
Msg-id FA20D4C4FEBFD148B1C0CB09913825FC01EBE7CE97@XCH-SW-06V.sw.nos.boeing.com
Whole thread Raw
Responses Re: Need to Reload a Dump File - Need to Delete the PGDATA directory Again?  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view 
Hi All,

I'm in the processing of migrating to Postgres 8.3.8.
I did  :
(1) initdb
(2) psql -e template1 -f 21.bak &>/tmp/out21.bak

Now, I've  decided that I want to reload the same file again, do I just delete the PGDATA directory and then
perform the same steps again?
(1) initdb
(2) psql -e template1 -f 21.bak &>/tmp/out21.bak

What I'm asking is that do I always need to delete the PGDATA directory and then initdb to ensure that it will be a
cleanload? 

Thanks
Mary

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Scratching my head why results are different between machines.
Next
From: John R Pierce
Date:
Subject: Re: Need to Reload a Dump File - Need to Delete the PGDATA directory Again?