Moving PostgreSQL databse to another hard drive

[Ankhes]

Hello,

I have tried to move my PostgreSQL databse using these instructions: Hold'Em Manager 2 FAQs - Poker Software :: Move Database to Another Hard Drive or Partition
Unfortunately I have PostgreSQL 9.0 and some things are different - I did as was told there but in registry editor I have changed /HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Services\po stgresql-x64-9.0 Data Directory path to my new folder. Now when I try to run HM2 I'm getting error shmeme index entry size is wrong for data structure "XLOG Ctl" : expected 75096 actual 2108696. When I open pgAdmin III I don't have any database listed.

Best regards,


I have restarted comnputer and now I'm unable to connecto to postgresql at all. When I try to start it manually I get message that service started then stopped. Can I maybe just uninstall postgreSQL then install it on my external HDD and copy my data folder there?

[fozzy71]

If you are moving from a SSD to an external you could suffer a decrease in performance.

That being said, here are the instructions:

1) Uninstall PostgreSQL from the Windows Control Panel.

2) Run the command - start > programs > accessories > command prompt > right-click > run as administrator and type the following and then press enter:

net user postgres /delete

3) You should get a successfully completed response if done correctly. If you get a permission type error you likely didnt run it as administrator as explained above.

4) Reboot your PC

5) Install the same version of PostgreSQL as your previous database from postgresql.org using these instructions - Hold'Em Manager 2 FAQs - Poker Software :: Reinstall PostgreSQL 8.4 while preserving database

6) Once installed you should disable the postgresql logging as instructed here - Hold'Em Manager 2 FAQs - Poker Software :: Large Log Files

[Ankhes]

Can I install 9.4? I can't find 9.0 installer on postgresql site.

Nevermind found installer.

[udbrky]

You can install either. We do not recommend 9.1