Re: harmonize password reuse in vacuumdb, clusterdb, and reindexdb

2023-07-28 Thread Nathan Bossart
On Wed, Jul 19, 2023 at 10:43:11AM -0700, Nathan Bossart wrote: > On Wed, Jun 28, 2023 at 10:24:09PM -0700, Nathan Bossart wrote: >> The same commit that added this comment (ff402ae) also set the >> allow_password_reuse parameter to true in vacuumdb's connectDatabase() >> calls. I found a message

Re: harmonize password reuse in vacuumdb, clusterdb, and reindexdb

2023-07-19 Thread Nathan Bossart
On Wed, Jun 28, 2023 at 10:24:09PM -0700, Nathan Bossart wrote: > On Wed, Jun 28, 2023 at 09:20:03PM -0700, Gurjeet Singh wrote: >> The comment on top of connect_utils.c:connectDatabase() seems pertinent: >> >>> (Callers should not pass >>> * allow_password_reuse=true unless reconnecting to the sa

Re: harmonize password reuse in vacuumdb, clusterdb, and reindexdb

2023-07-18 Thread Zhang Mingli
HI, On Jun 29, 2023 at 13:24 +0800, Nathan Bossart , wrote: > > Connecting to different databases with the same > host/port/user information seems okay. Have a look, yeah, cluster_all_databases/vacuum_all_databases/reindex_all_databases will get there. LGTM. Regards, Zhang Mingli

Re: harmonize password reuse in vacuumdb, clusterdb, and reindexdb

2023-07-18 Thread Gurjeet Singh
On Mon, Jul 17, 2023 at 1:47 PM Nathan Bossart wrote: > > Here is a new version of the patch in which I've updated this comment as > proposed. Gurjeet, do you have any other concerns about this patch? With the updated comment, the patch looks good to me. Best regards, Gurjeet http://Gurje.et

Re: harmonize password reuse in vacuumdb, clusterdb, and reindexdb

2023-07-17 Thread Nathan Bossart
of the patch in which I've updated this comment as proposed. Gurjeet, do you have any other concerns about this patch? -- Nathan Bossart Amazon Web Services: https://aws.amazon.com >From 85d0a1bbe62c4cc01b3fdba7c653f95b8472cc7a Mon Sep 17 00:00:00 2001 From: Nathan Bossart Date: Tue, 27 Jun

Re: harmonize password reuse in vacuumdb, clusterdb, and reindexdb

2023-06-29 Thread Nathan Bossart
On Wed, Jun 28, 2023 at 10:24:09PM -0700, Nathan Bossart wrote: > On Wed, Jun 28, 2023 at 09:20:03PM -0700, Gurjeet Singh wrote: >> Nitpicking: The patch seems to have Windows line endings, which >> explains why my `patch` complained so loudly. >> >> $ patch -p1 < v1-0001-harmonize-patch >> (

Re: harmonize password reuse in vacuumdb, clusterdb, and reindexdb

2023-06-28 Thread Nathan Bossart
On Wed, Jun 28, 2023 at 09:20:03PM -0700, Gurjeet Singh wrote: > The comment on top of connect_utils.c:connectDatabase() seems pertinent: > >> (Callers should not pass >> * allow_password_reuse=true unless reconnecting to the same database+user >> * as before, else we might create password exposur

Re: harmonize password reuse in vacuumdb, clusterdb, and reindexdb

2023-06-28 Thread Gurjeet Singh
On Tue, Jun 27, 2023 at 9:57 PM Nathan Bossart wrote: > > While looking at something unrelated, I noticed that the vacuumdb docs > mention the following: > > vacuumdb might need to connect several times to the PostgreSQL server, > asking for a password each time. > > IIUC this has

harmonize password reuse in vacuumdb, clusterdb, and reindexdb

2023-06-27 Thread Nathan Bossart
rom e6fa53e7a2b0903fc6a498f22f6b436b81b206ed Mon Sep 17 00:00:00 2001 From: Nathan Bossart Date: Tue, 27 Jun 2023 21:38:24 -0700 Subject: [PATCH v1 1/1] harmonize password reuse in vacuumdb, clusterdb, and reindexdb --- doc/src/sgml/ref/reindexdb.sgml | 14 -- doc/src/sgml/ref/vacuumdb.sgml |