pgAdminIII issue

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

pgAdminIII issue

Postby live2bet » Wed Aug 12, 2009 3:55 pm

Trying to backup data using pgAdminIII but got an error after typing in dbpass as password.
Image
Did the usual...
Running as Admin
PostgreSQL started
No clue what firewall i'm using, PT3 has been working and is still working.

Can someone help please.
live2bet
 
Posts: 58
Joined: Tue Aug 26, 2008 9:06 pm

Re: pgAdminIII issue

Postby kraada » Wed Aug 12, 2009 4:21 pm

That error implies your PostgreSQL server isn't running. Click Start --> Programs --> PostgreSQL --> Start Services, then try again (PT3 automatically starts the server, which is why you don't have to do this normally).
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: pgAdminIII issue

Postby live2bet » Wed Aug 12, 2009 10:24 pm

Thank kraada for the prompt reply.

Before i try it, can you advise roughly how much memory do i need for about 800k hands?
Was gonna try backing up with DVD.

Thanks.
live2bet
 
Posts: 58
Joined: Tue Aug 26, 2008 9:06 pm

Re: pgAdminIII issue

Postby WhiteRider » Thu Aug 13, 2009 3:10 am

I'm not sure how big the backup file will be for that but I'm pretty sure it will fit on a DVD.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: pgAdminIII issue

Postby live2bet » Thu Aug 13, 2009 3:08 pm

Same thing.
>start service>open pgAdminIII>error message.

Advise please.
live2bet
 
Posts: 58
Joined: Tue Aug 26, 2008 9:06 pm

Re: pgAdminIII issue

Postby kraada » Thu Aug 13, 2009 3:15 pm

Did you try starting the PostgreSQL service first?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: pgAdminIII issue

Postby live2bet » Thu Aug 13, 2009 3:22 pm

yes i did kraada.
Start service, then open pgAdminIII
live2bet
 
Posts: 58
Joined: Tue Aug 26, 2008 9:06 pm

Re: pgAdminIII issue

Postby kraada » Thu Aug 13, 2009 4:01 pm

The most likely cause then is that some firewall or anti-virus program is keeping PostgreSQL from starting. Can you try looking around to see what potential ones there are? The ones that give PostgreSQL the most trouble are Norton 360 and F-Secure (which can go under Charter Security Suite and a firewall program that comes with an ISP called Orange).
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: pgAdminIII issue

Postby live2bet » Fri Aug 14, 2009 1:24 pm

Yes kraada, im using norton 360.
Can you advise how to work on the firewall please?

Thanks.
live2bet
 
Posts: 58
Joined: Tue Aug 26, 2008 9:06 pm

Re: pgAdminIII issue

Postby kraada » Fri Aug 14, 2009 2:19 pm

Norton 360 should offer a free upgrade to version 3.0. Take the upgrade; 3.0 does not have nearly as many problems, but version 2.0 does not let PostgreSQL start regularly no matter what you try, and trust me, I've tried.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 34 guests

cron
highfalutin