PokerTracker


https://staging.pokertracker.com/forums/

PGadmin cant connect

https://staging.pokertracker.com/forums/viewtopic.php?f=17&t=21896

Page 1 of 1

PGadmin cant connect

PostPosted: Tue Aug 11, 2009 8:04 am
by carlos50
I am trying to backup my DB with this guide "Backup/Restore with PGAdmin", but PGadmin cant connect to server. It gives this error message:

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

Re: PGadmin cant connect

PostPosted: Tue Aug 11, 2009 8:15 am
by carlos50
Forgot some important info. PT3 connects without any problems.

Furthermore I tried the following:

unable to login to database (PT3_xxxx_xx_xx_xxxxxx) - reason:could not connect to server:connection refused(0x0000274D/10061) Is the server running on host "localhost" and accepting TCPT/IP connection on port 5432?
First thing to try is to restart the postgres service.
Start -> Programs -> Postgres -> Start Service.
If this doesn't help, try a reboot.
Update: try this;
Try stopping the service (Start -> Programs -> Postgres -> Stop Service), running a search on your computer for postmaster.pid and then deleting that file, then restarting the service and see if that helps.
Note that you may need to turn on 'View hidden files and folders', and the file seems to be in the folder './Program Files/postgresql/<version>/data'
See also: viewtopic.php?f=17&t=6332#p38285


postmaster.pid didnt exist

Re: PGadmin cant connect

PostPosted: Tue Aug 11, 2009 8:40 am
by WhiteRider
That's very strange. Is everything installed on one computer - i.e. you don't have postgres installed on another computer on your network?

Are you using Vista?
Are you running PGAdmin as Administrator (like you do with PT3)?
ATTENTION: Windows VISTA users, you must read this...

It could also be a firewall issue although since PT3 is able to connect that is unlikely - what firewall do you use?

Re: PGadmin cant connect

PostPosted: Tue Aug 11, 2009 9:16 am
by carlos50
Its all on the same comp. Im running Vista and running as administrator.

I am running ZoneAlarm Extreme Security. I used to run Kaspersky, but changed because I couldnt get it to work with Postgressql / PT3. This is the first time i am experiencing problems after this change.

Re: PGadmin cant connect

PostPosted: Tue Aug 11, 2009 10:41 am
by WhiteRider
carlos50 wrote:Im running Vista and running as administrator.

Just to clarify - are you launching PGAdmin as administrator? This is different to being logged in as an administrator.

I'll ask our postges expert to take a look at this and see if he can think of anything else.

Re: PGadmin cant connect

PostPosted: Tue Aug 11, 2009 10:51 am
by WhiteRider
The other posibility is that you might need to add an exception to your firewall to allow PGAdmin full access.

Re: PGadmin cant connect

PostPosted: Tue Aug 11, 2009 12:15 pm
by carlos50
I am launching as administrator.

I have tryed to give PGadmin all priviligies in my security system. I am not home in this program though, so I might be missing something.

and thx for the assistance.

Re: PGadmin cant connect

PostPosted: Wed Aug 12, 2009 5:44 am
by WhiteRider
Please schedule a remote assistance session where someone can logon to your computer with you and directly troubleshoot/resolve the issue.

Re: PGadmin cant connect

PostPosted: Wed Aug 12, 2009 7:50 am
by carlos50
ok, i will do that, when i have a little more time.
All times are UTC - 5 hours [ DST ]
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/
highfalutin