Postgres Pro
Downloads
Home   >   mailing lists

Thread: Emergency - postgre is not working

Emergency - postgre is not working

From
"anika evans"
Date:
Hello,
 
I recently updated my  norton anti-virus and norton goback - and up until then - everything for my sambc was working fine now when I try and open sambc and I received the error message:

X 2006-07-09 22:09:19 [CORE] Connection to database failed (could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?

 I went to the postgresql.conf and I added listen_addresses='*' under the # CONNECTIONS AND AUTHENTICATION section.

It still did not work:

When I tried to start the server - I got the error message -

Failed to start server pgsql-8.0 Errcode = 1069

I also noticed that when I start windows xp - that I have two accounts owner(administrative) account and postgre account.  The postgre account requires a password.  The password that is listed on sambc/core.xml file does not work.

How do I fix the problem and also get into the postgre account??  or remove the postgre account all together

HELP
Anika Evans

Re: Emergency - postgre is not working

From
"Harald Armin Massa"
Date:
Anika,

thanks for the complete error description, I bet the culprit is in here:

I recently updated my  norton anti-virus and norton goback - and up until then - everything for my sambc was working fine now when I try and open sambc and I received the error message:


X 2006-07-09 22:09:19 [CORE] Connection to database failed (could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?

We had many times trouble with antivirus and similiar products interfering with the connections between pgadmin / psql and the Postrges Server.

I recommend to NOT remove the postgres account!!

Please try to configure Norton whatever to allow connections on Port 5432. Or roll back that update.

Best wishes,

Harald


--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
on different matter:
EuroPython 2006 is over. It was a GREAT conference. If you missed it, now you can prepare budget for visiting EuroPython 2007.

Re: Emergency - postgre is not working

From
"Harald Armin Massa"
Date:
Hello Anika,

please see that we are in different timezones, and I usually try to sleep at night. Please also try to keep your mail on the list, so others can try to help you as well.

Now, dig deeper in the analyzis:

1st) Logon as Admin, checkout services.msc

is there a postgres service running? If not, why not? Any messages there? Try to start the service from service control panel. Check out system event log, application event log.

2nd) where is your PostgreSQL data directory? in a standard installation it is in <program files>\postgres\8.1\data

there should be a log directory within, chechout what is in the youngest logfiles. Maybe post it to the list.

3rd) Try to connect to postgres using psql; that is the command line utilitie

4th) what is Postgresql used for on your computer? "sambc/core.xml" is no application I know connected to "pgadmin". I forwarded your mail to the postgres support list, because propably the problem is NOT connected to the pg-admin

Additional information: the password within the .xml file is most propably the passwort for the user within the database. NOT the postgres Service Account password.  The password of the postgres account should be irrelevant for you, since it is only used for the service to connec.t

Best wishes,

Harald




On 7/11/06, anika evans <hianika@gmail.com> wrote:
HELLO!!

I STILL NEED HELP -
I removed norton internet security and norton goback - postgre sql still doesn't work!!!!!
 
I need to get this thing running - asap - before my ass is fired!!
 


 
On 7/10/06, anika evans <hianika@gmail.com> wrote:
Unfortunatly rolling back the update did not work - and adding port 5432 did not work either.
 
If I cant remove postgre - then what do I do??
 
also, When I turn on the computer I have 2 accounts on windows ex - the Owner (administrator) account and a postgre account - the postgre acccount requires a password - unfortunatly when I get the password from sambc/core.xml file - the password does not work.... HELP
 
Thank you
Anika Evans
On 7/10/06, Harald Armin Massa <haraldarminmassa@gmail.com > wrote:
Anika,

thanks for the complete error description, I bet the culprit is in here:

I recently updated my  norton anti-virus and norton goback - and up until then - everything for my sambc was working fine now when I try and open sambc and I received the error message:

 

X 2006-07-09 22:09:19 [CORE] Connection to database failed (could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?

We had many times trouble with antivirus and similiar products interfering with the connections between pgadmin / psql and the Postrges Server.

I recommend to NOT remove the postgres account!!

Please try to configure Norton whatever to allow connections on Port 5432. Or roll back that update.
 

Best wishes,

Harald


--
GHUM Harald Massa
persuadere et programmare
 
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
on different matter:
EuroPython 2006 is over. It was a GREAT conference. If you missed it, now you can prepare budget for visiting EuroPython 2007.





--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
on different matter:
EuroPython 2006 is over. It was a GREAT conference. If you missed it, now you can prepare budget for visiting EuroPython 2007.