postgres 9 unable to connect to server

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

postgres 9 unable to connect to server

Postby MoniesRemovalPLC » Mon Jul 04, 2011 3:46 pm

i have been successfully running postgres 9 and PT3 for a few weeks, i recently installed HEM, and tried running it / postgres off the same port as my PT3 database. it worked and i created a new HEM database, after that I looked in PGadmin assistant and it showed both databases in there. But when i restart my PC now i couldnt access the databases in either program - it just says "unable to connect with server" and then prompts me to create a new DB. a further error message states :

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

also when i try and run PGadmin i cant access the databse to view it. I have tried a complete uninstall / reinstall of postgres and PT3 also to try and fix this, and even with a brand new empty DB and no HEM database i get the same problem.
MoniesRemovalPLC
 
Posts: 348
Joined: Tue Mar 22, 2011 2:38 pm

Re: postgres 9 unable to connect to server

Postby WhiteRider » Mon Jul 04, 2011 3:48 pm

Are you able to start the PostgreSQL service? Click Start (in XP click Run) and type "services.msc" - find PostgreSQL and attempt to start it.
If it doesn't start, do you see any errors related to PostgreSQL in the Event Viewer (Start, type "event viewer")?
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: postgres 9 unable to connect to server

Postby MoniesRemovalPLC » Mon Jul 04, 2011 4:07 pm

i can't start the service, in event viewer there are 2 errors listed as postgres errors in the last hour / 14 errors in last 7days
MoniesRemovalPLC
 
Posts: 348
Joined: Tue Mar 22, 2011 2:38 pm

Re: postgres 9 unable to connect to server

Postby WhiteRider » Tue Jul 05, 2011 3:41 am

Often PostgreSQL is prevented from starting by an overzealous firewall so please check our Firewall Guide.
If that doesn't help please write (or attach a screenshot of) the error message in a Support ticket and our support technicians will work with you to get things working again.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: postgres 9 unable to connect to server

Postby MoniesRemovalPLC » Tue Jul 05, 2011 4:49 am

thx WR, actually i had just updated my COmodo firewall so looks like that was the cause, will send report if problem continues
MoniesRemovalPLC
 
Posts: 348
Joined: Tue Mar 22, 2011 2:38 pm

Re: postgres 9 unable to connect to server

Postby WhiteRider » Tue Jul 05, 2011 7:40 am

That could be it - Comodo is known to cause problems, and there is a section on it in the guide.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 27 guests

cron
highfalutin