Page 1 of 2

Trying to backup DB

PostPosted: Sat Sep 05, 2009 5:59 pm
by defence18
Followed directions, can't connect pgAdminIII because "server won't listen." No firewalls enabled, edited config file, no avail. Version 8.3. Please tell me wtf is going on before I throw my comp.

Re: Trying to backup DB

PostPosted: Sun Sep 06, 2009 4:27 am
by WhiteRider
That sounds like the postgres service isn't running, try: Start > Programs > Postgres > Start Service, then try PGAdmin again.
Which config file did you edit, and what did you do to it?

Re: Trying to backup DB

PostPosted: Sun Sep 06, 2009 3:17 pm
by defence18
Tried to start service, Didn't help. I edited the postgresql.conf file that it recommeneded. It suggested that I open all ports by replacing "local host" with " * " That didn't help, so I switched it back.

Re: Trying to backup DB

PostPosted: Sun Sep 06, 2009 3:54 pm
by WhiteRider
Is postgres running?
Have a look at Task Manager > Processes; do you see any postgres.exe processes?

Are you using Vista?
Are you running PGAdmin as administrator (like you do with PT3)?

Re: Trying to backup DB

PostPosted: Sun Sep 06, 2009 7:23 pm
by defence18
No, I don't see it under task manager. I am using Vista, but it's in safe mode because the HD is f'ed up and it's the only way I can access my comp. I think I am the admin, but not 100% sure.

Re: Trying to backup DB

PostPosted: Mon Sep 07, 2009 4:27 am
by WhiteRider
Running applications as administrator is different to being logged in as administrator.
You need to run all your poker software as administrator for PT3 to work correctly, and I suspect the same applies to PGAdmin since it needs to connect to the postgres service.
Right click the PGAdmin shortcut and choose "Run As Administrator".

Re: Trying to backup DB

PostPosted: Tue Sep 08, 2009 10:00 am
by defence18
Tried running both PGAdmin and Start Service as admin. Still get the server won't listen error.

Re: Trying to backup DB

PostPosted: Tue Sep 08, 2009 10:22 am
by kraada
Please check to make sure your firewall isn't blocking PostgreSQL from starting (the Firewall Troubleshooting Guide may come in handy) as that can cause this sort of problem.

Re: Trying to backup DB

PostPosted: Tue Sep 08, 2009 10:34 pm
by defence18
No firewalls are running. McAfee is disabled, as is the windows firewall.

Re: Trying to backup DB

PostPosted: Wed Sep 09, 2009 4:21 am
by WhiteRider
Are you still running in Safe Mode? It's possible that is preventing the postgres service from starting.
Are you able to boot into normal mode even temporarily?

highfalutin