PDA

View Full Version : Problem with postgres



Steinpilz0104
04-08-2013, 06:29 PM
Hi

A fellow of pokerstrategy.fr reported me that he has problems with his postgres installation. He found these informations: http://forums.holdemmanager.com/manager-general/372801-hem1-not-working-please-help.html however it does not fit. The infos:

* His PC's name ise "PC"
* His user name is "Arch"
* The secondary log on is automatic
* UAC, Anti virus and Firewall are desactivated, not installed
* no net user postgres
* He installes it in c:\postgresql
* everything under admin
* he relaunched the PC


Details:

Output folder: C:\Program Files (x86)\PSQLINSTALL
top level install dir -->C:\Program Files (x86)
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: 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: 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:\Program Files (x86)\testfile
Extract: postgresql-8.4.7-1-windows.exe... 100%
Execute: "C:\Program Files (x86)\PSQLINSTALL\postgresql-8.4.7-1-windows.exe" --mode unattended --superpassword postgrespass
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

Patvs
04-08-2013, 11:16 PM
Let him try installing PostgreSQL 8.2 to port 5433.
http://ftp.postgresql.org/pub/binary/v8.2.22/win32/postgresql-8.2.22-1.zip

Steinpilz0104
04-17-2013, 01:23 PM
Hi Patrick

It works with 8.2; however he can't move to HM2 with that. How can he pass again to 8.4?

Patvs
04-17-2013, 10:58 PM
Turn on the Windows Firewall, and set exceptions to postgres.exe, pg_ctl.exe, and the port.
Install PostgreSQL to a different port.

If 8.4, 9.0 or 9.2 won't install, he can just use 8.2 for HM2.

Steinpilz0104
04-26-2013, 07:38 AM
Hi Patrick

He can't only install HM2 even he has postgres installed; the installation of HM2 has a forced installation of postgres. I think there is the problem; The installation does not recognize the existing postgres installation.

He has installed postgres separately.

Steinpilz0104
04-26-2013, 09:15 AM
Hi Patrick

He has already 8.2 installed.

Patvs
04-27-2013, 12:44 AM
When using the full installer, you can choose to only install 'HoldemManager', just untick 'PostgreSQL' so 8.4 won't be forced installed.

Steinpilz0104
04-27-2013, 01:10 AM
Hi Patrick

That does not work; he can't unclick the postgres installation, probably HM2 does not recognize the Postgres 8.2 installed?

Patvs
04-27-2013, 01:32 AM
Then install PostgreSQL 8.2 to a different port, for example port 5433.

Ignore the fact the full installer installs (or attemps to install) PostgreSQL 8.4 to port 5432.

When you start HM2 and 8.4 on port 5432 is not running properly, you'll get the database screen where you can change the port, so HM2 will use 8.2 instead:


110181