'configure postgreSQL databse' ???

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Re: 'configure postgreSQL databse' ???

Postby tellmama » Fri Jun 13, 2014 11:28 am

Hi,

I have the same problem:

Unable to login to database (postgres). Reason: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "???" and accepting TCP/IP connections on port 5432?

There is no firewall interfering and when I try to start postgres in services error 1053 occures.
I checked the events relating to postgres: all errors read: GMT FATAL: bogus data in lock file "postmaster.pid": ""
What can I do?
tellmama
 
Posts: 2
Joined: Tue Apr 23, 2013 10:47 am

Re: 'configure postgreSQL databse' ???

Postby kraada » Fri Jun 13, 2014 11:55 am

Locate and delete the postmaster.pid file then restart your computer and things should work properly. The file is likely in a place like C:\Program Files\PostgreSQL\9.0\data (though it may be in Program Files (x86) or have a different version number).
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: 'configure postgreSQL databse' ???

Postby tellmama » Fri Jun 13, 2014 3:02 pm

Thanks very much for the quick help. Now it's working properly again. I hope the file was not the result of a virus or something similar.
tellmama
 
Posts: 2
Joined: Tue Apr 23, 2013 10:47 am

Re: 'configure postgreSQL databse' ???

Postby kraada » Fri Jun 13, 2014 3:36 pm

That's highly unlikely.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Previous

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 26 guests

cron
highfalutin