Hello,
I am experiencing the following while using PostgreSQL
9.6.3-1.pgdg16.04+1 (deb package from official repository):
1. with "\set AUTOCOMMIT off" in my psqlrc, issue a
"SELECT * FROM pg_stat_activity;" and leave it there
2. in a different connection, issue a database REINDEX (of any database
different from 'postgres')
* Any further attempt to create new connections to the server, to any
database, does not succeed and leads to a "FATAL: canceling authentication
due to timeout" in the server logs.
* The REINDEX doesn't actually complete unless I end the transaction
started at point 1.
Is this expected? I am failing to see the relation between an idle
transaction in the 'postgres' database, a reindex operation and
subsequent logins.
Thank you very much for your attention,
Best regards
--
https://s19n.net
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general