Thread: problem connecting to server

problem connecting to server

From
Trigve Siver
Date:
Hi
 
I have installed PostgreSQL 8.1 on windows XP with SP2 ... Everything is working fine, but sometimes when I want to connect to DB via pgadmin or command line or with some library, I can't connect. When this happen no error is shown but pgadmin is not responding and when connecting via command line, when I enter the password nothing is done. It looks like it is connecting but without succes. But when I restart the computer everything is OK then. This error happen not so often. I can't replicate it.
 
In log file is something like this:
....
2006-06-19 12:00:38 LOG:  terminating any other active server processes
2006-06-19 12:00:38 LOG:  all server processes terminated; reinitializing
2006-06-19 12:00:41 LOG:  background writer process (PID 132500) exited with exit code 0
2006-06-19 12:00:41 LOG:  terminating any other active server processes
2006-06-19 12:00:41 LOG:  all server processes terminated; reinitializing
2006-06-19 12:00:43 LOG:  background writer process (PID 133080) exited with exit
...
 
thanks Trigve
 
 


Yahoo! Sports Fantasy Football ’06 - Go with the leader. Start your league today!

Re: problem connecting to server

From
"Qingqing Zhou"
Date:
"Trigve Siver" <trigves@yahoo.com> wrote
>
>   I have installed PostgreSQL 8.1 on windows XP with SP2 ...
>
>   2006-06-19 12:00:38 LOG:  terminating any other active server processes
> 2006-06-19 12:00:38 LOG:  all server processes terminated; reinitializing
> 2006-06-19 12:00:41 LOG:  background writer process (PID 132500) exited
with exit code 0
> 2006-06-19 12:00:41 LOG:  terminating any other active server processes
> 2006-06-19 12:00:41 LOG:  all server processes terminated; reinitializing
> 2006-06-19 12:00:43 LOG:  background writer process (PID 133080) exited
with exit
>   ...

Looks like the server try hard to restart. Is there any PANIC message you
found in the log?

Regards,
Qingqing



Re: problem connecting to server

From
"Qingqing Zhou"
Date:
"Trigve Siver" <trigves@yahoo.com> wrote
>
> Thank you for reply. No there isn't any panic message. Log contain only
> messages I have posted.
>

Check out this thread (or search "background writer process exited" in
list):

http://archives.postgresql.org/pgsql-general/2006-05/msg01568.php

Regards,
Qingqing



Re: problem connecting to server

From
Trigve Siver
Date:
Hi,
 
Thank you, for the link... was helpfull.
 
Trigve


Qingqing Zhou <zhouqq@cs.toronto.edu> wrote:

"Trigve Siver" wrote
>
> Thank you for reply. No there isn't any panic message. Log contain only
> messages I have posted.
>

Check out this thread (or search "background writer process exited" in
list):

http://archives.postgresql.org/pgsql-general/2006-05/msg01568.php

Regards,
Qingqing



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings


Sneak preview the all-new Yahoo.com. It's not radically different. Just radically better.