Date: Wed, 5 Feb 2020 13:30:05 -0500
From: Stephen Frost <sfrost@snowman.net>
To: =?iso-8859-1?Q?J=FCrgen?= Purtz <juergen@purtz.de>
Cc: pgsql-docs@lists.postgresql.org, jbird@nuna.com
Subject: Re: Users/Roles do not align.
Message-ID: <20200205183005.GX3195@tamriel.snowman.net>
References: <158057750885.1123.2806779262588618988@wrigleys.postgresql.org>
 <2a273cf6-51be-a25b-5ef6-915ca727d4db@purtz.de>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="Un9uPUwkPLHod62y"
Content-Disposition: inline
In-Reply-To: <2a273cf6-51be-a25b-5ef6-915ca727d4db@purtz.de>
User-Agent: Mutt/1.5.24 (2015-08-30)
Precedence: bulk


--Un9uPUwkPLHod62y
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Greetings,

* J=FCrgen Purtz (juergen@purtz.de) wrote:
> >Based on this, I believe Section 5.9 should read:
> >`A PostgreSQL database cluster contains one or more named databases. Rol=
es
> >are shared across the entire cluster, but no other data is shared across
> >databases. Any given client connection to the server can access only the
> >data in a single database, the one specified in the connection request.`
>=20
> imo the following is a more precise wording:
>=20
> 'A cluster contains three or more named databases ('template0', 'template=
1',
> 'postgres', ...). Roles, which are users or groups, see Chapter 21, - as

Roles aren't 'users or groups', they're roles, and we don't actually
have users or groups today.

> well as database names and tablespace definitions - are shared across the
> entire cluster. No other data is shared across databases or schemas. Any
> given client connection to the server can access only the data in a single
> database, the one specified in the connection request. If it has the
> necessary privileges, the connection can access all schemas within this
> database.'

There's a few things wrong about this part anyway- namely that we've got
FDWs now, and there's certainly other cluster-wide things that exist
beyond the specific items listed, so I wonder if perhaps we should just
stop trying to list everything here.  The description given in 22.1
seems like it's a lot better since it talks about the hierarchy in a
general sense.

The minimalistic approach suggested initially seems like it might be the
best answer to this right now.

Thanks,

Stephen

--Un9uPUwkPLHod62y
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBCgAGBQJeOwmsAAoJEO1sijiDR2RVT1UP/ir9Nt+SX5RGr8rR1rPvGlJ8
ffkhgMgdj/gyhri7W96G/vPhDIZS6WtLGkYXv/2HcZgexU0SEZIgwJdXDngpb8sb
q3EzzQZOvsxz3Mj8zWUp8c1c2ny3BjR+lsFnyYbI+bHGhJzndVvbyBqAH1c1zyPD
djv/nkK+XTpf3HDt3HuTmDVRHD7hw0SLAxPsF10SidnUyY/6bvcB4Mctn2wMwdk8
52CIwngBjz7xqI4jvUJxJliS1jUtAEwu5lCB4rAGFkZ90NBY7YtCmaOSodX+xpgV
sF3KHET+uUEviALsT0rix297Efuuvta4uShmHZnNoGFvsfCjGoMLXJu3tVNv7fdT
rK9CgKLm3gzGCw7oQFvC1SC+qfKfFnmY9r9RGbK0G7GNIl86glT7fbFO6LZLShuN
d2Pfdvd04d4YF6JECdRA0Oe/z12hfTx7vQD35TJq29WqtIQCrGCndWexq8H/xbZX
geGeqgMlrkbtKRbYMoux03ho4z6PW9fANMEOOkBR5ee9PbvgCh9EsjyqGYT1cwng
C9OxTDP31toLws6fl0qqGti/Uay7DML5LEROBEsN70iUGmmyJo12X7GU99HUkNii
fo5m4SWODF7wIZRIZRe7tDEG9FEf1eYDdrdzDT2LfCunKWrf1qaXS9h5AmXJ5Qgw
vFjRX12xJYx/8wWJ/oCz
=wz2y
-----END PGP SIGNATURE-----

--Un9uPUwkPLHod62y--