postgres installation

[dan233]

hi
just purcahsed a new pc (windows 7)
installing postgres throught the combo installer failed so
I m trying to install postgres 8.4 to my laptops D:drive seperately, as advised.
the following error message appears after the installation:
[IMG][/IMG]
any ideas?

[netsrak]

Please try Postgresql 8.3: http://www.enterprisedb.com/getfile.jsp?fileid=806

We don't know why but on some Windows 7 installations postgresql 8.4 fails to install.

[dan233]

Please try Postgresql 8.3: http://www.enterprisedb.com/getfile.jsp?fileid=806

We don't know why but on some Windows 7 installations postgresql 8.4 fails to install.

hi
did what you said; installed postgressql 8.3
same problem:
[IMG][/IMG]
I had uninstalled the other version using revo and removed postgres user through the command promt as admin previous to this..

[fozzy71]

Which Firewall, and Anti-Virus are you using?

Try turning down the UAC setting and reboot. Make sure you right-click > run as administrator when installing .exe files.

If you are still having problems, try our old 8.3 installer. Unzip to a new folder and then run the small .msi file. http://www.holdemmanager.com/downloads/postgresql.zip

You could also try older versions from here - http://www.postgresql.org/ftp/binary/

[dan233]

Which Firewall, and Anti-Virus are you using?

Try turning down the UAC setting and reboot. Make sure you right-click > run as administrator when installing .exe files.

If you are still having problems, try our old 8.3 installer. Unzip to a new folder and then run the small .msi file. http://www.holdemmanager.com/downloads/postgresql.zip

You could also try older versions from here - http://www.postgresql.org/ftp/binary/

ok I m trying to install the data directory to D drive it says this:
[IMG][/IMG]my guess is that you cant install it on the D: partition without named subfolders?like this default one for example:[IMG][/IMG]
so did you create these subfolders?( or is the problem something else)

[netsrak]

Create a folder like d:\postgresql and choose this folder as the installation destination. It seems to make problems if you install directly to D:

[dan233]

Create a folder like d:\postgresql and choose this folder as the installation destination. It seems to make problems if you install directly to D:

Ok that part worked.
I was prompted to put a "password" during the installation process.[I] dont know if this is to actually "create" a password but i just added a random one :"postgres"
now, when i try to access this "localhost" section(shown by the arrow) i am asked for a password. when i add the one i added during installation I get the following error message. is this normal?

[IMG][/IMG]

[fozzy71]

PT3's default name/password is - postgres/dbpass
HM's default name/password is - postgres/postgrespass

If that doesnt help:

1. Go to C:\Program Files\PostgreSQL\8.x\data, move the the pg_hba file to your Desktop and open it with notepad.
2. Scroll to the bottom and change all md5 to trust. Save and close the file
3. Move the file back to the data folder
4. Restart the PostgreSQL service: Control Panel -> Administrative Tools -> Services

HM will accept any password now.

http://faq.holdemmanager.com/questio...es+(PostgreSQL)

[dan233]

PT3's default name/password is - postgres/dbpass
HM's default name/password is - postgres/postgrespass

If that doesnt help:

1. Go to C:\Program Files\PostgreSQL\8.x\data, move the the pg_hba file to your Desktop and open it with notepad.
2. Scroll to the bottom and change all md5 to trust. Save and close the file
3. Move the file back to the data folder
4. Restart the PostgreSQL service: Control Panel -> Administrative Tools -> Services

HM will accept any password now.

http://faq.holdemmanager.com/questio...es+(PostgreSQL)

I cant find the data folder (I have ticked the "show hidden folders")[IMG][/IMG]
No pg_nba file in the "bin" folder either..

[fozzy71]

It must have been installed to a different (Data) drive, like D:\

You should be able to find the data folder path by looking at the image path in the registry.



Windows XP
Go to Start > Run and type the following in the textbox: regedit and then press enter and a new window should appear like in the screenshot below:

Windows Vista/W7
Go to Start > All Programs > Accessories > Run then type the following in the textbox: regedit and then press enter and a new window should appear like in the screenshot below:



Navigate the folders to this path: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\pgsql-8.2 and you should then see the following screen:



In the image above ive highlighted an example. Go to image path and right click and choose modify and you should see the following:

"C:\Program Files\PostgreSQL\8.2\bin\pg_ctl.exe" runservice -w -N "pgsql-8.2" -D "C:\Program Files\PostgreSQL\8.2\data\"

The last set of quotes is the data path.