Re: Danger of automatic connection reset in psql

On 11/14/16 5:41 AM, Oleksandr Shulgin wrote:
> Automatic connection reset is a nice feature for server development,
> IMO. Is it really useful for anything else is a good question.

I use it all the time for application development; my rebuild script
will forcibly kick everyone out to re-create the database. I put that in
because I invariably end up with a random psql sitting somewhere that I
don't want to track down.

What currently stinks though is if the connection is dead and the next
command I run is a \i, psql just dies instead of re-connecting. It'd be
nice if before reading the script it checked connection status and
attempted a reconnect.

> At least an option to control that behavior seems like a good idea,
> maybe even set it to 'no reconnect' by default, so that people who
> really use it can make conscious choice about enabling it in their
> .psqlrc or elsewhere.

+1, I don't think it needs to be the default.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532) mobile: 512-569-9461