Re: Danger of automatic connection reset in psql

2016-11-11 5:14 GMT+01:00 Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>:

> >
> > How about, instead of all this, adding an option to psql to suppress
> > the automatic reconnect behavior? When enabled, psql just exits
> > instead of trying to reconnect.
> >
> +1. But, existing users may not notice addition of the new option and
> still continue to face problem. If we add the option and make it
> default not to reconnect, they will notice it and use option to get
> older behaviour, but that will break applications relying on the
> current behaviour. Either way, users will have at least something to
> control the connection reset.
>

The reconnect in not interactive mode is a bad idea - and there should be
disabled everywhere (it cannot to break any application - the behave of
script when a server is restarted must be undefined (100% if ON_ERROR_STOP
is active). In interactive mode it can be controlled by some psql session
variables like AUTOCOMMIT.

Regards

Pavel

>
>
>
> --
> Best Wishes,
> Ashutosh Bapat
> EnterpriseDB Corporation
> The Postgres Database Company
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>