alisazegar wrote:
> Hi All,
>
> I'm having difficulties with Postgres lately. Postgres service for (pgsql
> 8.2 )kept stopping every few minutes.
> Then I read a note somewhere saying that there is a bug in 8.2 which causing
> the problem.
> I switched to 8.3 and have the same problem.
It's running happily on my Vista Business laptop. Well, as happily as
anything runs on Windows ;-)
> What I found so far is that the last event before stopping is "loaded
> library LOG: loaded library "$libdir/plugins/plugin_debugger.dll" which I
> see it in windows logs (events) for applications.
That's normal and appears in my logs as well.
Try having a look at the logs in the database directory. By default,
that'll be:
%PROGRAMFILES%\PostgreSQL\8.3\data\pg_log
If you don't see anything useful, consider increasing the log level by
editing postgresql.conf and changing log_min_messages from:
#log_min_messages = notice
to
log_min_messages = debug1
Also, check to see if all postgresql processes are terminating or
whether it's just the master.
--
Craig Ringer