PDA

View Full Version : PostgreSQL Error upon installation



TheBoon
02-21-2010, 06:56 AM
Upon installing PostgreSQL, I get this error.
I'm currently using Windows 7 Professional.
I turned UAC off, windows defender, and the firewall, if that helps.
After clicking "ok" it continues to install the rest of the stuff.
When I open HEM, PostgreSQL can't initialize.
Not sure how to solve this problem.
Any help is appreciated, thanks.

http://www.liquidpoker.net/user_pictures/ff75c.postgres4error.jpg

netsrak
02-21-2010, 07:30 AM
Are you using the Holdemmanager installer with Postgresql or a separate Postgresql installer?

Please try a 8.3 version from ruby on rails postgresql open at postgresq.org (http://www.postgresq.org)

TheBoon
02-21-2010, 07:50 AM
Are you using the Holdemmanager installer with Postgresql or a separate Postgresql installer?

Please try a 8.3 version from ruby on rails postgresql open at postgresq.org (http://www.postgresq.org)

Yeah I used the combo installer, didn't work.
Used the seperate installer, didn't work.

I had Windows 7 RC client before, and everything was installed and worked fine.
I just updated to the real Windows 7 Professional, and now it's giving me this error whenever I try to install PostgreSQL.

The link you posted didn't work. I tried installing Version 8.3.9-1 from the postgresql.org site, but it still gave me that same error.
:confused:

UAC disabled, also tried running the installs as adminstrator just in case, nothing worked.
I also tried installing it into a different directory "C:\PostgreSQL" but it still wasn't working. :(

"postgres installdir: C:\Program Files (x86)\PSQLINSTALL
==================== running PsqlTestClient
try pass: postgres
try pass: postgrespass
Connection to database failed: -->could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
<--error
1
testclient return status: 1
testclient return from file: 1
==================== finished PsqlTestClient
no existing install dir
wrote testfile
Delete file: C:\Program Files (x86)\testfile
Extract: postgresql-8.4.1-1-windows.exe... 100%
Execute: "C:\Program Files (x86)\PSQLINSTALL\postgresql-8.4.1-1-windows.exe" --mode unattended --superpassword postgrespass
postgres installdir: C:\Program Files (x86)\PSQLINSTALL
==================== running PsqlTestClient
try pass: postgres
try pass: postgrespass
Connection to database failed: -->could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
<--error
1
testclient return status: 1
testclient return from file: 1
==================== finished PsqlTestClient"

That's what I get from the installer when I click "details" after it says "Sorry, could not install PostgreSQL"

I pretty much have the same problem as these guys in this thread http://forums.holdemmanager.com/manager-general/26416-windows-7-problem-failed-establish-connection-127-0-0-1-service-postgresql.html

morny
02-21-2010, 01:55 PM
Do you have a 3rd party firewall, sometimes you need to completely uninstall it then install postgreSQL and then you can reinstall the firewall once its working.

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily - FAQ - Hold'em Manager Poker Tracking Software :: Windows Firewall / Defender Problems (http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems) - Windows Firewall / Defender Problems

If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:
A) Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator

net user postgres /delete
B) Reboot.
C) Try installing this version of PostgreSQL - http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe

TheBoon
02-21-2010, 05:26 PM
yeah no 3rd party firewall, everything is turned off.
tried everything, adding exceptions to windows firewall didn't work either.
restarted the pc many, many times too.

i also tried installing http://www.holdemmanager.com/downloads/Pos...3.9-v1.0.7.exe, though it said postgres successfully installed, it didn't bring up the screens where i could setup the postgres account and passwords, and ended up not working as well.

like i said, it was running perfectly fine and everything installed fine on windows 7 RC client, just upgraded and did a clean install to Windows 7 prof. and it's not working anymore.

TheBoon
02-21-2010, 05:58 PM
ok I found the problem from trying to install postgresql 8.2
http://www.liquidpoker.net/user_pictures/f731d.seclogon.jpg

not sure how to fix this though, trying to look up info on google atm.
okay, so I enabled secondary logon, and tried installing postgresql 8.4 again, and gave me the same error :( very confused now

Patvs
02-22-2010, 02:51 AM
Is this Windows 7 Professional x64 (English version)? How much RAM do you have?


SQL (any version you install) gives a crazy error at the very end...
it actually installed everything but the SQL/data directory is empty?

Can I ask if it's a legal Windows 7 Professional?
I've seen the problem before... wasn't able to fix it. Recommended to install Windows 7 ULTIMATE x86 (if < 3 GB RAM) or x64 (if > 4 GB RAM).. that fixed it.

TheBoon
02-22-2010, 04:06 AM
yeah, its Windows 7 professional, genuine copy.
I've found a fix for the problem

I went to control panel-> administrative tools-> services-> secondary logon
right clicked it and started the service.

then i installed postgreSQL 8.2
PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.15/win32/postgresql-8.2.15-1.zip)

everything works fine now.