Thursday, November 5, 2009

Postgres PGDATA folder location change

Step1: stop the postgre service



Step2: Copy the PGDATA(data) folder to a new location

Step3: Goto regedit(Windows) HKEY_LOCAL_MACHINE->SYSTEM->CurrentControlSet->Services->postgresql"version"



Step4: Edit ImagePath, change the location of the data* folder



Step5: Edit the postgre service, check "path to executable" the data folder should get changed.



Step6: Start the postgre service.

*note: The data folder location should have the Administrator writes in order to start the service

No comments:

Post a Comment