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
...
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
Note: forwarded message attached.
---------------------------------
Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.
Import Notes
Resolved by subject fallback
"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.