Friday, December 20, 2019

Change the default PGDATA directory on Windows

In case we need to change the default postgres data folder just because we have an existing postgres data folder. So that we can do like the following to archive it.

1. First we have to stop postgres service in window
2. Open regedit by typing in window + R.
3. Look into the directory link and edit it to the corresponding postgres data folder
Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\postgresql-x64-9.5



4. Start postgres service again and enjoy working.

No comments:

Post a Comment