PDA

View Full Version : PostgreSQL issues



phantom_lord
11-10-2012, 11:36 AM
I've reinstalled HM1 after not using for a few months and I've having issues with PostgreSQL.

I followed the instructions here with no results.

http://faq.holdemmanager.com/questions/91/Can't+Connect+%7B47%7D+Failed+to+Start+PostgreSQL+

When I try uninstalling and reinstalling PostgreSQL I get a message saying

"Sorry could not install PostgreSQL"



Output folder: A:\Program Files (x86)\PSQLINSTALL
top level install dir -->A:\Program Files (x86)
Is admin account
.NET found
Extract: TestFirewall.exe... 100%
Extract: TestFirewall.exe.config... 100%
Antivirus Installed: False
test antivirus returned 0
seclogon error status: 0
seclogon status: 4
firewall enabled: 0
firewall not enabled
postgresql error status: 1060
postgresql status: 0
starting pgsql-8.3
postgresql error status: 1060
postgresql status: 0
postgresql error status: 1060
postgresql status: 0
starting postgresql-8.4
postgresql error status: 1060
postgresql status: 0
postgres installdir: A:\Program Files (x86)\PSQLINSTALL
==================== running PsqlTestClient
try userid: postgres
try pass: postgrespass
try pass: postgrespass
Connection to database failed: -->server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
<--error
1
testclient return status: 1
testclient return from file: 1
==================== finished PsqlTestClient
granting write permission on top level postgres directory
found dir
try rename A:\Program Files (x86)\PostgreSQL\8.4 --> A:\Program Files (x86)\PostgreSQL\8.4-prev-2012-09-Jun-20-06-34
Create folder: A:\Program Files (x86)\PostgreSQL\8.4-prev-2012-09-Jun-20-06-34
Moving files: A:\Program Files (x86)\PostgreSQL\8.4\*.* to A:\Program Files (x86)\PostgreSQL\8.4-prev-2012-09-Jun-20-06-34\
Remove folder: A:\Program Files (x86)\PostgreSQL\8.4\
renamed dir
wrote testfile
Delete file: A:\Program Files (x86)\PostgreSQL\testfile
Extract: postgresql-8.4.7-1-windows.exe... 100%
Execute: "A:\Program Files (x86)\PSQLINSTALL\postgresql-8.4.7-1-windows.exe" --mode unattended --superpassword postgrespass
postgres installdir: A:\Program Files (x86)\PSQLINSTALL
==================== running PsqlTestClient
try userid: postgres
try pass: postgrespass
try pass: postgrespass
Connection to database failed: -->server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
<--error
1
testclient return status: 1
testclient return from file: 1
==================== finished PsqlTestClient



Attached is the error message from when hm tries to connect to the database.

Patvs
11-10-2012, 03:57 PM
Turn on the secondary Logon. The secondary logon service is a standard windows service which is available on every windows computer. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services. Starting it once should insure it works in the future also.


Install PostgreSQL with the installer from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org).

Also check your hosts file:
http://holdemmanager.net/forum/showthread.php?t=8182

Or install SQL 8.2 which will always run: http://ftp.postgresql.org/pub/binary/v8.2.22/win32/postgresql-8.2.22-1.zip

sjokkomoes
11-21-2012, 03:28 PM
i too cannot install postgres. Secondary logon is turned on.
Output folder: C:\Program Files (x86)\PSQLINSTALL
top level install dir -->C:
Is admin account
fs=NTFS
.NET found
Extract: TestFirewall.exe... 100%
Extract: TestFirewall.exe.config... 100%
Antivirus Installed: False
test antivirus returned 0
seclogon error status: 0
seclogon status: 4
firewall enabled: 1
firewall port 5432 enabled: 0
port 5432 not added
set port 5432 enabled
postgresql error status: 1060
postgresql status: 0
starting pgsql-8.3
postgresql error status: 1060
postgresql status: 0
postgresql error status: 1060
postgresql status: 0
starting postgresql-8.4
postgresql error status: 1060
postgresql status: 0
postgres installdir: C:\Program Files (x86)\PSQLINSTALL
==================== running PsqlTestClient
try userid: postgres
try pass: postgrespass
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:\testfile
Extract: postgresql-8.4.7-1-windows.exe... 100%
Create folder: c:\postgreSQL
Execute: "C:\Program Files (x86)\PSQLINSTALL\postgresql-8.4.7-1-windows.exe" --mode unattended --superpassword postgrespass --prefix c:\postgreSQL --datadir c:\postgreSQL\data
postgres installdir: C:\Program Files (x86)\PSQLINSTALL
==================== running PsqlTestClient
try userid: postgres
try pass: postgrespass
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

udbrky
11-21-2012, 05:23 PM
- Please see these steps to fix postgresql connection issues:

http://hm2faq.holdemmanager.com/questions/1001/Can+not+Connect+November47?+Failed+to+Start+Postgr eSQL+

- Please make sure that you have allowed postgres and pg_ctl in your firewall and antivirus exceptions. They are in postgres\bin.

- Please update windows fully. Please keep checking until it shows twice five minutes apart that there are no more updates.

- Please update your network adapter. Open device manager and find the model #. Search google for the model # drivers to download.

- Please run the windows repair on your winsock:

How to determine and to recover from Winsock2 corruption in Windows Server 2003, in Windows XP, and in Windows Vista (http://support.microsoft.com/kb/811259)

Also try port forwarding in your firewall.