PDA

View Full Version : PostgreSQL won't install



THE_TRUTH
11-25-2010, 02:10 PM
My postgreSQL still won't install i've followed all the FAQ's. I have tried both installers, both didn't work. On the manual installer neither passwords work. On the main installer this comes up (edited down):


Output folder: C:\Program Files (x86)\RVG Software\Holdem Manager\Temp
Output folder: C:\Program Files (x86)\RVG Software\Holdem Manager
Create folder: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Holdem Manager
Create shortcut: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Holdem Manager\Holdem Manager.lnk
Create shortcut: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Holdem Manager\Uninstall Holdem Manager.lnk
Create shortcut: C:\Users\Public\Desktop\HoldemManager.lnk
Created uninstaller: C:\Program Files (x86)\RVG Software\Holdem Manager\UninstallHoldemManager.exe
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: 1
starting seclogon
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
granting write permission on top level postgres directory
found dir
try rename C:\Program Files (x86)\PostgreSQL\8.4 --> C:\Program Files (x86)\PostgreSQL\8.4-prev-2010-19-Nov-11-13-01
Create folder: C:\Program Files (x86)\PostgreSQL\8.4-prev-2010-19-Nov-11-13-01
Moving files: C:\Program Files (x86)\PostgreSQL\8.4\*.* to C:\Program Files (x86)\PostgreSQL\8.4-prev-2010-19-Nov-11-13-01\
Remove folder: C:\Program Files (x86)\PostgreSQL\8.4\
renamed dir
wrote testfile
Delete file: C:\Program Files (x86)\PostgreSQL\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 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


My firewall is off and user account control is off. I have no security system. Please help thanks

THE_TRUTH
11-25-2010, 04:43 PM
Just saw this: http://forums.holdemmanager.com/manager-general/8182-fix-postgresql-cannot-start-error-127-0-0-1-a.html

but cannot find the "hosts" file in there

netsrak
11-26-2010, 05:00 AM
Please try to download and install postgresql 8.4 from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org).
If that fails try 8.3 and 8.2.

Sometimes it helps to install postgresql on a different partition.

THE_TRUTH
11-26-2010, 12:34 PM
Neither password that is advised to use will work

Patvs
11-27-2010, 03:07 AM
Delete the postgres user first, and it will accept any password:

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 /del' (without the quotes) and press enter.

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

THE_TRUTH
11-27-2010, 12:39 PM
PostgreSQL is now installed but it will not connect to Holdem MANAGER: "Failed to establish a connection to '127.0.01'. Is there any chance I could get some remote support as I really need to get HEM up and running for a prop bet and for my SN run on stars?

Patvs
11-27-2010, 09:06 PM
This is usually a firewall or windows update issue.

First try to reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service

If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it. And reboot.


If that doesn't help you will have to reinstall PostgreSQL completely