Date: Mon, 18 Jan 2021 16:19:49 +0100
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: psycopg@lists.postgresql.org, psycopg@postgresql.org
Subject: Re: Designing a better connection pool for psycopg3
Message-ID: <YAWnFSR2HIbR1hhM@hermes.hilbert.loc>
Mail-Followup-To: psycopg@lists.postgresql.org, psycopg@postgresql.org
References: 
 <CA+mi_8aZQXzB8Kr4V0nps3aMQ74N72uWC=pZF0P1H7AW4GLasA@mail.gmail.com>
 <YAWJcSDmciAKptEK@hermes.hilbert.loc>
 <CA+mi_8a-0Wx62eziOBwp-=ryBynsqrgx4AcBGW5+pSr3vZXjHg@mail.gmail.com>
 <CABUevExMQQB3=xShPie+XR04kctiR8-P_BEUz1BmCyDLhU_yhg@mail.gmail.com>
 <CA+mi_8a83=Qy-Ym+_X4tLPcD1YHVVVYF2Ki5jeHU4eDz_etG5w@mail.gmail.com>
 <CABUevEy6iYxAgH6qFJN5OqiPFkv1O1JU90jbHna2xDXqFDLFHg@mail.gmail.com>
 <CA+mi_8aMCUW873qcN1vghtMQEXX78vSLj5+LtO5dQyy_2rbbeg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CA+mi_8aMCUW873qcN1vghtMQEXX78vSLj5+LtO5dQyy_2rbbeg@mail.gmail.com>
Ma_X_il-Followup-to: d
Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net
Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net
X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net
X-Pri_X_ority: 2 (High)
Sender: <karsten.hilbert@gmx.net>
X-Provags-ID: V03:K1:5E8GBlt2Sih6H4lZ05OKhRPIuWPxKV559Ty6a+WF7nZXJWBTzxA
 6GChagRQxCiKyzA2YBFXn3nhKSB/Qke9XCrI092jEZ3LjeCwFXyD/e/C1dATS2BWFpHiZWZ
 KIsUroVdvsIU+Z5fYVOUsYKXM9YQpm4MkobA9Nh3WNDHhytKxU4GRcgkknlqI3ni2wsp0BV
 K/j2+7rQY4Mu22UjOw+VA==
X-Spam-Flag: NO
X-UI-Out-Filterresults: notjunk:1;V03:K0:VoBwU8Emr8M=:7qmQOSxs6r2/6dX/gZw8fN
 3Uysc19OI6O3ifTjuUxO3ANR2ZDImlOxDPs9DZK35oRJQ0e0HMBUmKL/yvtJMxFrIfSjPUY0T
 40xLBM8kyHBJntVqSwSEH/h0SJvSD7OKwdwKsymg4Ke7UWOVtehux6k6ieS5ZOUly6ufbiIzp
 WR5vxDxp2rRzNhUXobD6hAk1QZuJnUmb5glLUPkIFWTCRvPg0KHW446vjU2UmMIlH7RKILhQ0
 kQPGXnh4digVrycz9XnMoFR05s+aGVhIZOu4JAbuWP0k24SM+nytvcBtQgJBROKqtxgXz24fA
 uwoxNyCPC6chrHoqQKke2iO6RxKxc0oDakSOMi/xWg50j+OAYzB5WkYtEv8dANxv3sq7406xE
 cKAj3Hlm6PIW1IYOSd+ILMDfK7OIZZ7E+zdP7Uy5163mg9Bu3wljRUtGcxnzMS/2X5cICakAe
 CGdl1QGt4KOZ7q0a9/bRmWuwfANGHkTI4Sfbnynr4y/u/qs2aV8QjM56BmLHyaWsVJpMTu677
 pjEiSTJZvumZezoUNisNOcrqnk7QN5Zvx1xNqU+X4Ej8d+5U4kqrppfzLRcwyMB36R2dNfP5+
 qNFQcy1cUNbLoxxMS33TlnzMkcu40WuhLVB+Phtfc9P0Tpx/F5NYtxLpz0gjRrV7Gtl7PjmHr
 Ebd1fXCTJYDgjF0/+GwG77fNOoO2+JSYP8zs7F2c/+NHl9TMsPqaUaGgEAKUq8wIWD7K0DCXu
 RIit7rCgQgcjFTjANtFHGiLErDKXbB4z2+UphpwBlvxDOeIwX1VwSzwIcILpm3cb0DfyC/klb
 CnwIc2gylZrYGja7UfbxL+xBCSGvbIItGzDO1znXz9qTB6K1x+MoFD1+9z1ARPdp7ihZy8tjW
 NoWmf5tyOEF2GdDqYThSDWNaXSOw79/A2eYVOCCDY=
Content-Transfer-Encoding: quoted-printable
List-Id: <psycopg.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:psycopg@lists.postgresql.org>
List-Owner: <mailto:psycopg-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/psycopg>
Precedence: bulk

Am Mon, Jan 18, 2021 at 04:12:05PM +0100 schrieb Daniele Varrazzo:

> > > partition or reconfiguration, and the app server doesn't see the
> > > database anymore. This node is arguably broken.
> >
> > Only if this is the *only* thing it does.
> >
> > It might still be able to reach other services on other nodes. Other
> > databases. Heck, even other database son the same node if it was a
> > config error.
>
> In your opinion (and Karsten's, if he'd like to chip in), what should
> happen on program start? Is attempting to create a new connection in
> the main thread, and throwing an exception if failing to do so, a
> reasonable behaviour?

Sure ! The app can always catch that and decide what to do.

Karsten
=2D-
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B