470,647 Members | 1,187 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

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!

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

Nov 11 '05 #1
2 1604
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 ma*******@postgresql.org)

Nov 11 '05 #2
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 ma*******@postgresql.org

Nov 11 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Oli Schwarz | last post: by
24 posts views Thread by Esmail Bonakdarian | last post: by
4 posts views Thread by Brian Henry | last post: by
4 posts views Thread by Dylan Parry | last post: by
reply views Thread by streamkid | last post: by
1 post views Thread by Korara | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.