Thread: problem connecting to server
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
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-general/2006-05/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-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.