[GENERAL] uptime problem

2003-08-20 Thread Vasili G. Yanov

 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!



---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [GENERAL] uptime problem

2003-08-20 Thread Shridhar Daithankar
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


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])


Re: [GENERAL] uptime problem

2003-08-20 Thread Shridhar Daithankar
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


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]