Trying to backup DB

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

Trying to backup DB

Postby defence18 » Sat Sep 05, 2009 5:59 pm

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.
defence18
 
Posts: 13
Joined: Sat Aug 02, 2008 9:07 pm

Re: Trying to backup DB

Postby WhiteRider » Sun Sep 06, 2009 4:27 am

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?
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Trying to backup DB

Postby defence18 » Sun Sep 06, 2009 3:17 pm

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.
defence18
 
Posts: 13
Joined: Sat Aug 02, 2008 9:07 pm

Re: Trying to backup DB

Postby WhiteRider » Sun Sep 06, 2009 3:54 pm

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)?
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Trying to backup DB

Postby defence18 » Sun Sep 06, 2009 7:23 pm

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.
defence18
 
Posts: 13
Joined: Sat Aug 02, 2008 9:07 pm

Re: Trying to backup DB

Postby WhiteRider » Mon Sep 07, 2009 4:27 am

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".
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Trying to backup DB

Postby defence18 » Tue Sep 08, 2009 10:00 am

Tried running both PGAdmin and Start Service as admin. Still get the server won't listen error.
defence18
 
Posts: 13
Joined: Sat Aug 02, 2008 9:07 pm

Re: Trying to backup DB

Postby kraada » Tue Sep 08, 2009 10:22 am

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.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Trying to backup DB

Postby defence18 » Tue Sep 08, 2009 10:34 pm

No firewalls are running. McAfee is disabled, as is the windows firewall.
defence18
 
Posts: 13
Joined: Sat Aug 02, 2008 9:07 pm

Re: Trying to backup DB

Postby WhiteRider » Wed Sep 09, 2009 4:21 am

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?
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Next

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 19 guests

cron
highfalutin