cant load database

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

cant load database

Postby supamanc » Sun Feb 13, 2011 8:30 pm

I receive thus message whenever i attempt to run PT:

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

any advice?
supamanc
 
Posts: 2
Joined: Fri Feb 08, 2008 1:27 pm

Re: cant load database

Postby WhiteRider » Mon Feb 14, 2011 4:50 am

Click Start (on Windows XP click Run), type services.msc and hit enter. Locate the PostgreSQL entry from the list - is the service started? If not, can you start it?
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: cant load database

Postby supamanc » Mon Feb 14, 2011 7:23 am

hi, the service is not running, when i run it it starts then stops, giving a message about unused services stopping themselves!
supamanc
 
Posts: 2
Joined: Fri Feb 08, 2008 1:27 pm

Re: cant load database

Postby kraada » Mon Feb 14, 2011 10:08 am

Then please check to make certain that your firewall or anti-virus is not blocking PostgreSQL - that is the most common cause for that kind of error.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: cant load database

Postby Kinkykiwi » Thu Feb 24, 2011 12:55 am

I am getting the same error as above. it all started when i could not update the windows Live essential's update and I had to run resetvista.cmd to get update to load after that i recieve error "unable to create postgres database"Pt3_2011_02_24_143313 Reason: unable to log on 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 on port 5432."
I have my databases backup on another drive. I tried uninstalling all and re installing postgres and pokertracker from scratch and this did not solve issue. what else can I try
running windows vista home prem.
Macafee anti virus and firewall all configured with full access and it still dont work.
Postgres not in Task manager so tried to start server and got this message
system error 1069 has occurred
THE SERVICE DID NOT START DUE TO LOGON FAILURE.
ideas please.
Paul
alais Kinkykiwi
Kinkykiwi
 
Posts: 1
Joined: Mon May 11, 2009 2:59 am

Re: cant load database

Postby Yorkie6013 » Thu Feb 24, 2011 5:14 am

a windows update this week caused this on mine, it removed PT from the firewall allowed list.......2nd time its done this to me this year.......i just readded it and it works fine again.
Yorkie6013
 
Posts: 94
Joined: Fri Mar 06, 2009 11:52 am

Re: cant load database

Postby WhiteRider » Thu Feb 24, 2011 9:12 am

That kind of error does normally indicate a permissions issue, often related to a firewall. Please do check that you still have everything configured as described in the Firewall 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 26 guests

cron
highfalutin