PDA

View Full Version : Setting up 2nd PC error with Postgres on install



Freedom
11-14-2010, 08:11 PM
Right, someone please save me from my tired postgres error madness!

I'm trying to set-up a second machine as I'm trying to do a video on my laptop and it doesn't like it so it goes extremely slow. So, I decided to install HEM and poker client on an old desktop. The trouble comes when I go to start after the install and the following comes up. Help Please:-


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: 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
no existing install 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

Patvs
11-15-2010, 01:23 AM
Manually download and install SQL 9.0.1 from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)
Password during installation is postgrespass

If it doesn't accept the password, delete the postgres user first: Hi,

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 install PostgreSQL.

Freedom
11-15-2010, 11:57 AM
Did this, but the following came up:-


Problem running post-install step. Installation may not complete correctly
Error reading file C:Program Files/PostgreSQL/9.0/data/postgresql.conf

netsrak
11-15-2010, 12:47 PM
Which operating system?
Any firewall or other security software?

Please try postgresql 8.4 and 8.3 instead (PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)).

Freedom
11-15-2010, 12:54 PM
Running XP 32bit. Super AntiSpyware. Thats about it, apart from Microsoft standard Firewall. Postgre is under exemption with the Firewall

Freedom
11-15-2010, 03:13 PM
but the 8.4 was the one I had initially!?! The one with the auto install.

A miracle would be really handy right now. I am supposed to be doing a 1 hour video that is supposed to be done and with someone in less than 6 hours. So, tilted atm

Patvs
11-15-2010, 11:18 PM
Our installer is 8.4.1
If you install 8.4.5 from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org) (which will update your installation) it often fixes any problems.

Let us know which error you get during installation of 8.4.5