Message-ID: <bd77411d3581a6c483e7cb09838bb32c35c00383.camel@cybertec.at>
Subject: Re: database specific pg_read_all_data / pg_write_all_data
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: richard coleman <rcoleman.ascentgl@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Date: Wed, 10 Dec 2025 15:45:27 +0100
In-Reply-To: 
 <CAGA3vBtp2H4+v-AnWLq_w8TVAuHS5++6dHW98YN1-q7N66ywYQ@mail.gmail.com>
References: 
	<CAGA3vBug6Sq_XYLxzmY470WFS6Z3OF28goYzX=QHrCc4hgQSDw@mail.gmail.com>
	 <72acf8ae4e56886081b9f632569f290d3246c33b.camel@cybertec.at>
	 <CAGA3vBuWjNdz=zfMNvpqYRJRdQCapbexWnD4kgOss2PMbw5ZZw@mail.gmail.com>
	 <8536f893e79693bd0a23d4cea7dbe0b6366378df.camel@cybertec.at>
	 <CAGA3vBtp2H4+v-AnWLq_w8TVAuHS5++6dHW98YN1-q7N66ywYQ@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/bd77411d3581a6c483e7cb09838bb32c35c00383.camel%40cybertec.at>
Precedence: bulk

On Wed, 2025-12-10 at 09:10 -0500, richard coleman wrote:
> Running many clusters on a single server, while possible, reduces the amo=
unt of memory
> available to each cluster and each database process users run respectivel=
y.

Yes, but not a by much.

> ALTER DEFAULT PRIVLIGES doesn't work on schema that doesn't exist at that=
 time that command was run.

That is not true.  The IN SCHEMA clause is optional.
You have to run one ALTER DEFAULT PRIVILEGES for each role that is to creat=
e tables, but
if you have many such roles, you are probably doing something wrong.

> I am sorry to hear that you think "pg_read_all_data" is ugly.

That is a purely personal judgement.  I am sure many people find the featur=
e useful.

> That built-in role and others like it have proven very useful for a fairl=
y common
> use case; a small group of users that must share database objects between=
 them without
> having to constantly rejigger privileges on those objects.

I cannot claim to know what people do out there, but I must say that I have=
n't
encountered many such setups in the field.  Usually such "ad hoc" schemes r=
un into
trouble by the time when people want to drop tables.

Yours,
Laurenz Albe