postgres problem, cant log in to database?

[jmflu]

I have had 2 different versions of postgres installed (because a while ago I was required to to convert a PT2 db) but everything has worked fine for months and months with PT3 and today I tried to log in and now it only says (in the players tab)

Unable to log into database. Reason: could not connect to server. Connection refused (0x0000274D/10061) Is the server running on host localhost and accepting tcp/ip connections on port 5432.

So when I go into the postgres admin and look at the localhost:5432 it is not connected or running. Is this the problem? If so how do I fix it when I try to connect it asks for a password that I dont know and when I click start service it doesnt seem to do anything.

Ay help would be great

[jmflu]

and I tried everything mentioned in the FAQ and not working .....

My postgres 8.2 runs fine but 8.3 just will not start service at all

[_dave_]

if pgadmin asks for a password, it would seem something is running... open an admin command prompt and type

Code: Select all

netstat -a

see if port 5432 is "listening"

[jmflu]

5432 does not show up in the command prompt

[APerfect10]

That just means the PostgreSQL database server is not started (or any other database listening on port 5432).

Start the PostgreSQL service via Start->Programs->PostgreSQL then send me your last three PostgreSQL log files via the support system.

PM me with your Ticket # once submitted and I'll look at it immediately.

Best regards,

Derek

[jmflu]

when I go to start service it opens up the dos screen and the service is starting followed by a lot of . . . . . . . . . . . . . for a few minutes then goes away although it appears to not actually start.

Also, where do I find the log files for this?

[WhiteRider]

Looks like they might be in ...
C:\Program Files\PostgreSQL\8.3\data\pg_log

[jmflu]

thank you

[jmflu]

APerfect10 is trying to help me through the support system but in the meantime does anyone else have any suggestions?