Re: could not open file "global/pg_filenode.map": Operation not permitted

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Nick Renders <postgres(at)arcict(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: could not open file "global/pg_filenode.map": Operation not permitted
Date: 2024-03-13 11:35:26
Message-ID: ZfGPfsckcxYLtagw@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

* Nick Renders (postgres(at)arcict(dot)com) wrote:
> > ...run them under different users on the system.
>
> Are you referring to the "postgres" user / role? Does that also mean setting 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Kohnert 2024-03-14 07:36:57 Re: Implementing product-aggregate
Previous Message John McKown 2024-03-13 02:32:38 Re: Fwd: Receipt for PostgreSQL US Invoice #1840