Re: could not open file "global/pg_filenode.map": Operation not permitted - Mailing list pgsql-general

From Stephen Frost
Subject Re: could not open file "global/pg_filenode.map": Operation not permitted
Date
Msg-id ZfGPfsckcxYLtagw@tamriel.snowman.net
Whole thread Raw
In response to Re: could not open file "global/pg_filenode.map": Operation not permitted  (Nick Renders <postgres@arcict.com>)
Responses Re: could not open file "global/pg_filenode.map": Operation not permitted  (Nick Renders <postgres@arcict.com>)
List pgsql-general
Greetings,

* Nick Renders (postgres@arcict.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
thoughthe 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

Attachment

pgsql-general by date:

Previous
From: John McKown
Date:
Subject: Re: Fwd: Receipt for PostgreSQL US Invoice #1840
Next
From: Jan Kohnert
Date:
Subject: Re: Implementing product-aggregate