Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1owJaW-0003Ae-Qb for pgsql-general@arkaria.postgresql.org; Sat, 19 Nov 2022 08:52:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1owJaV-0003Im-9q for pgsql-general@arkaria.postgresql.org; Sat, 19 Nov 2022 08:52:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1owJaU-00038C-UO for pgsql-general@lists.postgresql.org; Sat, 19 Nov 2022 08:52:34 +0000 Received: from mail.hjp.at ([212.17.106.138] helo=rorschach.hjp.at) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1owJaO-0003oG-8q for pgsql-general@lists.postgresql.org; Sat, 19 Nov 2022 08:52:33 +0000 Received: by rorschach.hjp.at (Postfix, from userid 1000) id A42AA82A9; Sat, 19 Nov 2022 09:52:25 +0100 (CET) Date: Sat, 19 Nov 2022 09:52:25 +0100 From: "Peter J. Holzer" To: pgsql-general@lists.postgresql.org Subject: Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Message-ID: <20221119085225.uivmxue2gef5utv2@hjp.at> Mail-Followup-To: pgsql-general@lists.postgresql.org References: <290EF7B8-D150-4AE1-8FFE-A38912CD1A8B@yugabyte.com> <20221118200835.sgva7b6wgg4w7py7@hjp.at> <0B653B38-2D7D-45D6-B87F-DD07200EA676@yugabyte.com> <20221118221305.ku2ibj2bowahzn2y@hjp.at> <11d24370-18c6-f736-85db-e9ae1814bb64@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="tvz765fhygrng26g" Content-Disposition: inline In-Reply-To: <11d24370-18c6-f736-85db-e9ae1814bb64@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --tvz765fhygrng26g Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On 2022-11-18 16:21:18 -0600, Ron wrote: > On 11/18/22 16:13, Peter J. Holzer wrote: > > So you can give these credentials to you developers or devops folks > > (whom you trust not attack the system - >=20 > They like to "fix" things without documenting what they did, and then, wh= en > something breaks, denying they did anything (or honestly not believing th= at > whatever "trivial" thing they did could any major or deliterious impact). Which is why you want to automate deployments. When the easiest way to fix something in production is to just push the change into the repo, this is what people will do. When doing it the "proper" way is much more complicated than just fudging it, people will do the latter. hp --=20 _ | Peter J. Holzer | Story must make more sense than reality. |_|_) | | | | | hjp@hjp.at | -- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!" --tvz765fhygrng26g Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEETtJbRjyPwVTYGJ5k8g5IURL+KF0FAmN4mUQACgkQ8g5IURL+ KF1/Ew//R+BoBKELbvW2YMBgRSfdSH9vmvshcyH5tZRTGGThwPYkkKVx6LdEi3ok GUKCSun/H1szDBW0qpErk94TbYpt00bUeUziKgJc4oAvvQiZHcjtVpXgh5PyAZ5P /wr7rtOmXLLU2yldqnOgtOmLsbp7pLMJQvHlznOYcmJKdhZykoO4d85rgL0Fhx6w jqysG5G8/Og9nR3FyOov3SGyrR7gRc8iiRg6bSMyj3LqwLHfxS6ODN5eaxtPcAI+ +A48VqPsKwvkwbsybDclIeQ8akpHrMPmcG2mRdeHiS26OKBUSO8pezMNclbeMKhu okORSqlBrtKkkCEXEJczvBbjbRhk2cNXBCSsvLHrh545AIyXbch8ugdBmKgE6pfd 1M9iy0mBYSdnSwClrAEWzkw8ftVjbLfIKRrPuIdj1StHLC7cr86r7kZ1WihBLXR1 c7vdNga07tAfua0TbdNDsic1y9VFDeBFmv7OOchTySmkIfcZNz3Zz2qEEDefY1J/ 38cZQywUnCTZvn3s4TEEFTnIAfpnzf9sOzznruzQX+3gBcbEGQTb/weA/fESXZCv MnxSoVgVNN9mfSf75KKEDUNJwxzMbJlQKXMc++BKSpEzA61GuIINM9nQP6Wi3i6Z 3TbqAGYcfkQNW2q1IDnYhPTqNlophOIvfRHVQw1R7Q676sqkXb4= =a0NR -----END PGP SIGNATURE----- --tvz765fhygrng26g--