Обсуждение: Postgresql service stops every few minutes on Vista Biz

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.

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.


Any hint or idea to solve this problem is appretiated.

Regards,

Ali
--
View this message in context:
http://www.nabble.com/Postgresql-service-stops-every-few-minutes-on-Vista-Biz-tp17300359p17300359.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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

alisazegar <ali.sazegarnejad@gmail.com> writes:
> 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.

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

Does the problem go away if you remove that from the preload_libraries
setting?

            regards, tom lane