hello, i was wondering if there was any work done/planned/discussed about implementing support for this really useful feature of libpq:
$ psql 'postgres://host1:5432,host2:5432,host3:5432/postgres?target_session_attrs=read-write' Psycopg claims to support all dsn parameters. https://paquier.xyz/postgresql-2/postgres-10-libpq-read-write/ https://www.postgresql.org/docs/12/libpq-connect.html target_session_attrs If this parameter is set to read-write, only a connection in which read-write transactions are accepted by default is considered acceptable. The query SHOW transaction_read_only will be sent upon any successful connection; if it returns on, the connection will be closed. If multiple hosts were specified in the connection string, any remaining servers will be tried just as if the connection attempt had failed. The default value of this parameter, any, regards all connections as acceptable. this has the potential of making failover possible without any additional software. a quick search through the tickets and PRs brought up no results. -f -- -- You received this message because you are subscribed to the Google Groups "Django developers (Contributions to Django itself)" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-developers+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-developers/20200424085821.GA87143%40obiit.org.
