Need to Reload a Dump File - Need to Delete the PGDATA directory Again?

From: "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Need to Reload a Dump File - Need to Delete the PGDATA directory Again?
Date: 2010-03-04 07:08:48
Message-ID: FA20D4C4FEBFD148B1C0CB09913825FC01EBE7CE97@XCH-SW-06V.sw.nos.boeing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 clean load?

Thanks
Mary

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2010-03-04 07:22:02 Re: Need to Reload a Dump File - Need to Delete the PGDATA directory Again?
Previous Message Scott Marlowe 2010-03-04 01:57:20 Re: Scratching my head why results are different between machines.