Обсуждение: uptime problem

 I have trouble: when client-program broke connection to Postgre I see
in logs:

 FATAL:  This connection has been terminated by the administrator.
 LOG:  shutting down

 and I must start Postgre again. Postgre starting as:

 pg_ctl -D /usr/local/pgdata -o \"-S\" start

 I have PostgreSQL 7.3.4 (build from FreeBSD ports).

 Whats wrong?

 Thanks in advance!

On Wednesday 20 August 2003 18:51, Vasili G. Yanov wrote:
>  I have trouble: when client-program broke connection to Postgre I see
> in logs:
>
>  FATAL:  This connection has been terminated by the administrator.
>  LOG:  shutting down
>
>  and I must start Postgre again. Postgre starting as:
>
>  pg_ctl -D /usr/local/pgdata -o \"-S\" start

If you get rid of that  -S and specify a logfile, I am sure you will find
something in logs that would help you.

Discardign logs is not a good idea in general. Not especially if you have
problems..

 Shridhar

On Wednesday 20 August 2003 19:01, Vasili G. Yanov wrote:
> >>  I have trouble: when client-program broke connection to Postgre I see
> >> in logs:
> >>
> >>  FATAL:  This connection has been terminated by the administrator.
> >>  LOG:  shutting down
> >>
> >>  and I must start Postgre again. Postgre starting as:
> >>
> >>  pg_ctl -D /usr/local/pgdata -o \"-S\" start
>
> SD> If you get rid of that  -S and specify a logfile, I am sure you will
> find SD> something in logs that would help you.
>
> SD> Discardign logs is not a good idea in general. Not especially if you
> have SD> problems..
>
> I store all logs in syslog.

Hmm.. Looking at the error message again, looks like somebody is killing
postmaster.

Is there any other script which is trying to kick in?

HTH

 Shridhar