Re: psql casts aspersions on server reliability - Mailing list pgsql-hackers

From Tom Lane
Subject Re: psql casts aspersions on server reliability
Date
Msg-id 15946.1475068481@sss.pgh.pa.us
Whole thread Raw
In response to psql casts aspersions on server reliability  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: psql casts aspersions on server reliability
Re: [HACKERS] psql casts aspersions on server reliability
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> psql tends to do things like this:
> rhaas=# select * from pg_stat_activity;
> FATAL:  terminating connection due to administrator command
> server closed the connection unexpectedly
>     This probably means the server terminated abnormally
>     before or while processing the request.

> Basically everything psql has to say about this is a lie:

I cannot get terribly excited about this.  What you seem to be proposing
is that psql try to intuit the reason for connection closure from the
last error message it got, but that seems likely to lead to worse lies
than printing a boilerplate message.

I could go along with just dropping the last sentence ("This probably...")
if the last error we got was FATAL level.  I don't find "unexpectedly"
to be problematic here: from the point of view of psql, and probably
of its user, the shutdown *was* unexpected.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Logical Replication WIP
Next
From: Tom Lane
Date:
Subject: Re: Python3.4 detection on 9.6 configuration