Date: Wed, 13 Mar 2024 07:35:26 -0400
From: Stephen Frost <sfrost@snowman.net>
To: Nick Renders <postgres@arcict.com>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: could not open file "global/pg_filenode.map": Operation not
 permitted
Message-ID: <ZfGPfsckcxYLtagw@tamriel.snowman.net>
References: <4D67E594-098F-4234-87D8-68F827AF2531@arcict.com>
 <d947712004aa39633639bd5a23d6a6d6b6b2665a.camel@cybertec.at>
 <2E2F11F8-718A-4E6A-81E0-4F5CC1F1273A@arcict.com>
 <a08f7e54-0a6f-466b-b3fc-08165076c605@aklaver.com>
 <19556056-40E7-4FA3-A2A1-0A345AEBFD9E@arcict.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="JPRDnFoEzul0Ywhp"
Content-Disposition: inline
In-Reply-To: <19556056-40E7-4FA3-A2A1-0A345AEBFD9E@arcict.com>
User-Agent: Mutt/2.1.4 (2021-12-11)
Archived-At: <https://www.postgresql.org/message-id/ZfGPfsckcxYLtagw%40tamriel.snowman.net>
Precedence: bulk


--JPRDnFoEzul0Ywhp
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Greetings,

* Nick Renders (postgres@arcict.com) wrote:
> > ...run them under different users on the system.
>=20
> Are you referring to the "postgres" user / role? Does that also mean sett=
ing up 2 postgres installation directories?

Yes, two separate MacOS user accounts is what I was suggesting.  You
could use the same postgres binaries though, no need to have two
installation of them.  You'd need seperate data directories, of course,
as you have currently.

> This script runs on a daily basis at 4:30 AM. It did so this morning and =
there was no issue with cluster B. So even though the issue is most likely =
related to the script, it does not cause it every time.

Seems likely that it's some sort of race condition.

Thanks,

Stephen

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

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEwf6gbxKhD863zrx/7WyKOINHZFUFAmXxj34ACgkQ7WyKOINH
ZFW38w/+NV9vemAfsEOmTKvQmtMllFp2Ndfj8uEfuzFrhCPapGbeZKphjtZGMnUP
Pn9wwdxX5L+qEPKbGpd9gKYJMb+w95+DUAgFWONkyYfkZgIlnhyu7moLb9w9vTxU
Z6tOFN/258fHIZJ65gnGt8nh1G4o/6sNTwTe/guPMdUnm0aQGW+oLCC4PYJsS6Dy
iRW+nyJG/7YAPK+eBKHhf2NU3jVWxu6m2nsYR9E24Gd4OrYIRBMMzohFe0CdKZQ4
TjvwFcfQmpM5B9ZGSsdrrxyvwjDKMBab7O2YbGXRHjNtgEom/bWwV7QCszq+Yeh4
8uiltN80OZig1HQ+oOJVG2dUBoIBFmaKGp+uUH0wqbBnZTvDOwLLpDcmwxISEeTL
glgvSF4jr31tMhq70h05FAzcJEj4a3sWRF09svYwiRCdbDSoDlVGejuTJ5OAXGXL
oZmozkSnq6H1DDyCFP73lEnWc/E2KTdVNDSBn99s50xsatA3koP94ecdcBLQD76Y
sPc9Cim3ghHTN2g+t57UtvX5dspMwXs9DQPQQhHsbcCwG8PxITJS30WRatScm4NN
dwX5jDa6H/jCrk2oIkG+ptc/ja9UKtWAZ1/TcS9LmnM53dX9owdjQeNxJGd88qr5
GhmVXf74cd3fb57SQe/QDpG5ufDJ1w/Paiq1jjkENq5MNlnJ6Tw=
=LoO6
-----END PGP SIGNATURE-----

--JPRDnFoEzul0Ywhp--