PDA

View Full Version : "sorry,could not install PostgreSQL"



yangpenger
05-21-2010, 05:49 AM
I reinstall Windows,but I can not install holdem manager setup any more,it says:"sorry,could not install PostgreSQL"",following is the part of details:

seclogon status: 4
firewall enabled: 1
firewall port 5432 enabled: 1
port 5432 already 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\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\testfile
Extract: postgresql-8.4.1-1-windows.exe... 100%
Execute: "C:\Program Files\PSQLINSTALL\postgresql-8.4.1-1-windows.exe" --mode unattended --superpassword postgrespass
postgres installdir: C:\Program Files\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

Sarek
05-21-2010, 06:02 AM
1) which WIndows (full name with service packs) version you use?
2) is your Windows interface English? And regional settings
3) have you tried to install Postgre 8.3.10 (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.3.10/win32/postgresql-8.3.10-1.zip) ? In some cases with Win7 (or Vista) it works

yangpenger
05-21-2010, 08:08 AM
1) which WIndows (full name with service packs) version you use?
2) is your Windows interface English? And regional settings
3) have you tried to install Postgre 8.3.10 (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.3.10/win32/postgresql-8.3.10-1.zip) ? In some cases with Win7 (or Vista) it works
1)windows XP professional version 2002 sevice pack 3
2)Chinese,I think it is not the problem,because I can use holdemmanager before
3)I tried ,but failed

_Capt'n_Cardiac_
05-21-2010, 06:05 PM
Hi yangpenger

Your error message is mentioned here:
FAQ - Hold'em Manager Poker Tracking Software :: Can&#039;t Connect / Failed to Start PostgreSQL (http://faq.holdemmanager.com/questions/91/Can%27t+Connect+%7B47%7D+Failed+to+Start+PostgreSQ L+)

Try the fixes & let us know how you get on

yangpenger
05-22-2010, 11:46 AM
I almost try everything ,but not succeed yet.of course I uninstall the security products
I run holdem manager setup,but it says "sorry,could not install postgreSQL"at last. I post part of details below:
Created uninstaller: C:\Program Files\RVG Software\Holdem Manager\UninstallHoldemManager.exe
Output folder: C:\Program Files\PSQLINSTALL
top level install dir -->C:\Program Files
Is admin account
fs=FAT32
.NET found
Extract: TestFirewall.exe... 100%
Extract: TestFirewall.exe.config... 100%
Antivirus Installed: True
test antivirus returned 1
antivirus installed
security center error status: 0
security center status: 4
disabling security center
security center error status: 0
security center status: 1
disabled security center
seclogon error status: 0
seclogon status: 4
firewall enabled: 1
firewall port 5432 enabled: 1
port 5432 already 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\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
granting write permission on top level postgres directory
found dir
try rename C:\Program Files\PostgreSQL\8.4 --> C:\Program Files\PostgreSQL\8.4-prev-2010-17-May-22-40-46
Create folder: C:\Program Files\PostgreSQL\8.4-prev-2010-17-May-22-40-46
Moving files: C:\Program Files\PostgreSQL\8.4\*.* to C:\Program Files\PostgreSQL\8.4-prev-2010-17-May-22-40-46\
Remove folder: C:\Program Files\PostgreSQL\8.4\
renamed dir
wrote testfile
Delete file: C:\Program Files\PostgreSQL\testfile
Extract: postgresql-8.4.1-1-windows.exe... 100%
Execute: "C:\Program Files\PSQLINSTALL\postgresql-8.4.1-1-windows.exe" --mode unattended --superpassword postgrespass
postgres installdir: C:\Program Files\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

Sarek
05-22-2010, 12:02 PM
Problem is here:
fs=FAT32

Postgre requires NTFS file system
see here Converting FAT32 to NTFS in Windows XP (http://www.aumha.org/win5/a/ntfscvt.php)

yangpenger
06-04-2010, 11:37 AM
I tried everything,but it doesn't work yet,feel very bad.Can you help me through teamviewer?

netsrak
06-04-2010, 11:50 AM
If you have a FAT32 Partition we can't help you, you need NTFS to run postgresql.

In other cases please schedule a remote support session with our support. Email support@holdemmanager.net, with a link to this thread and your forum name, so we can setup a Teamviewer (http://www.holdemmanager.net/teamviewer) session.

yangpenger
06-04-2010, 11:10 PM
thank you,I have converted to NTFS.I will do as you suggest.

nothing
06-05-2010, 04:01 AM
I have the same problem but i have windows 7 , and the hard drive is on NTFS format.

nothing
06-05-2010, 05:20 AM
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\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\testfile
Extract: postgresql-8.4.1-1-windows.exe... 100%
Execute: "C:\Program Files\PSQLINSTALL\postgresql-8.4.1-1-windows.exe" --mode unattended --superpassword postgrespass
postgres installdir: C:\Program Files\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


Help anyone.

netsrak
06-05-2010, 07:41 AM
Please check this:
FAQ - Hold'em Manager Poker Tracking Software :: Can&#039;t Connect / Failed to Start PostgreSQL (http://faq.holdemmanager.com/questions/91/Can%27t+Connect+%7B47%7D+Failed+to+Start+PostgreSQ L+)
FAQ - Hold'em Manager Poker Tracking Software :: Software Security Problems (Firewall) (http://faq.holdemmanager.com/questions/339/Software+Security+Problems+%28Firewall%29)

I think its a firewall in your case

yangpenger
06-07-2010, 07:45 AM
:D My problem has been resolved,I feel very happy and released,because it had been my biggest headache for a long time.thanks the guy who help me through teamviewer.although I don't know his name,His patience and Professionalism impress me most.as my problem is a little special,he excluded many usual ways and finally killed my headache.:)

RiceFan
05-09-2011, 03:29 PM
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: 1
port 5432 already 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: D:\Program Files\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
granting write permission on top level postgres directory
no existing install dir
wrote testfile
Delete file: D:\Program Files\PostgreSQL\testfile
Extract: postgresql-8.4.7-1-windows.exe... 100%
Execute: "D:\Program Files\PSQLINSTALL\postgresql-8.4.7-1-windows.exe" --mode unattended --superpassword postgrespass
postgres installdir: D:\Program Files\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

Help,thx.

Patvs
05-09-2011, 07:06 PM
Make sure the secondary login is running:
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 manual installer from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)

If it doesn't accept 'postgrespass' as password during installation, delete the postgres user first:

click on Start and go to Programs -> Accessories -> Command Prompt

* If you are on Vista, rightclick and choose "Run as Administrator".


A black box should appear. Type 'net user postgres /delete' (without the quotes) and press enter.

The user is now deleted and you can (re)install PostgreSQL.