PDA

View Full Version : messed up my postgresql



questionss
03-14-2010, 10:18 AM
Hi,

So i had this problem again: http://forums.holdemmanager.com/manager-general/12171-move-database.html

i did step b from this guide FAQ ID # 154 - How do I setup Holdem Manager to share one database between two computers? (http://www.holdemmanager.net/FAQ/afmviewfaq.aspx?faqid=154)

my new path for the the db is now E:\Program Files\PostgreSQL\data

i guess i kind of messed up the imagepath in the reg now, bc i got pgsql 8.4 and in the guide v 8.2 was used:

C:\Program Files (x86)\PostgreSQL\8.4\bin\pg_ctl.exe" runservice -w -N "pgsql-8.4" -D "E:\Program Files\PostgreSQL\data

when i try to restart postgresql in administrative tools --> services, i get the error cannot find file specified

any idea what i did wrong ?

fozzy71
03-14-2010, 12:50 PM
Your registry entry looks OK, with the exception of a missing quotation mark at the beginning and end, but I assume that was just a copy/paste issue when making this thread.

I am not sure, but the easiest solution may be to reinstall postgresql and use the same database.

1) Uninstall PostgreSQL from the Windows Control Panel. This will not delete your database. It will leave behind a \PostgreSQL\data folder containing your database(s).
2) run the command - start > programs > accessories > command prompt > right-click > run as administrator

net user postgres /delete
3) Install this version of PostgreSQL - http://www.holdemmanager.com/downloads/postgresql_8.4.1.1.exe

Make sure you are installing to the same directory where your \PostgreSQL\data folder is. You need to pick the program folder (C: drive) and the data directory (E: drive).

http://i207.photobucket.com/albums/bb176/fozzy71/HEM/sql84/sql84-1b.png

http://i207.photobucket.com/albums/bb176/fozzy71/HEM/sql84/sql84-1c.png

questionss
03-14-2010, 01:09 PM
Your registry entry looks OK, with the exception of a missing quotation mark at the beginning and end, but I assume that was just a copy/paste issue when making this thread.

problem solved :D

thanks