SEO

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!

"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

"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...5/msg01568.php

Regards,
Qingqing

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...5/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.