Page 1 of 1

postgres problem, cant log in to database?

PostPosted: Tue Aug 19, 2008 6:05 pm
by 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

Re: postgres problem, cant log in to database?

PostPosted: Tue Aug 19, 2008 7:09 pm
by 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

Re: postgres problem, cant log in to database?

PostPosted: Tue Aug 19, 2008 8:16 pm
by _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"

Re: postgres problem, cant log in to database?

PostPosted: Tue Aug 19, 2008 9:08 pm
by jmflu
5432 does not show up in the command prompt

Re: postgres problem, cant log in to database?

PostPosted: Tue Aug 19, 2008 11:14 pm
by 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

Re: postgres problem, cant log in to database?

PostPosted: Wed Aug 20, 2008 4:01 am
by 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?

Re: postgres problem, cant log in to database?

PostPosted: Wed Aug 20, 2008 4:03 am
by WhiteRider
Looks like they might be in ...
C:\Program Files\PostgreSQL\8.3\data\pg_log

Re: postgres problem, cant log in to database?

PostPosted: Wed Aug 20, 2008 4:04 am
by jmflu
thank you

Re: postgres problem, cant log in to database?

PostPosted: Wed Aug 20, 2008 5:39 pm
by jmflu
APerfect10 is trying to help me through the support system but in the meantime does anyone else have any suggestions?