From: Tom Lane <tgl@sss.pgh.pa.us>
To: =?iso-8859-1?Q?Fran=E7ois?= SIMON <francois.simon@free.fr>
cc: Adrian Klaver <adrian.klaver@aklaver.com>, pgsql-general@postgresql.org
Subject: Re: post-bootstrap init : permission denied pg_description
In-reply-to: <ZuMfn0xPo91YJ+ao@corindon.frsi.fr>
References: <241898171.198702953.1726138710864.JavaMail.root@zimbra28-e5.priv.proxad.net> <5616584c-97c1-4b65-a6d5-a957782c44c1@aklaver.com> <ZuMQ44BSc4kpaBhK@corindon.frsi.fr> <ZuMfn0xPo91YJ+ao@corindon.frsi.fr>
Comments: In-reply-to =?iso-8859-1?Q?Fran=E7ois?= SIMON <francois.simon@free.fr>
	message dated "Thu, 12 Sep 2024 19:06:39 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <4039016.1726162691.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 12 Sep 2024 13:38:11 -0400
Message-ID: <4039017.1726162691@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/4039017.1726162691%40sss.pgh.pa.us>
Precedence: bulk

=3D?iso-8859-1?Q?Fran=3DE7ois?=3D SIMON <francois.simon@free.fr> writes:
> So the problem seems to come from xlc, and only at initdb step.
> I can see that initdb runs a backend postgres in single user mode.
> And this is this backend, when compiled with xlc, that shows :
> FATAL:  permission denied for table pg_description

Yeah.  This seems like it must be an xlc code-generation bug.
It's got nothing to do with filesystem permissions: you're failing
an ACL check at the logical "table" level, which you should not
be because single-user mode implies superuser permissions.

We do have one buildfarm member building with 64-bit xlc on
AIX 7.1:

https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Dhornet&dt=3D2024=
-09-11%2003%3A51%3A02

I see that that uses a bunch of odd CFLAGS, but they look like they
are mostly to suppress compiler warnings.  Another important bit of
the recipe for AIX is -D_LARGE_FILES=3D1, but I'm not sure that that
would have any impact during initdb (since we're not dealing with
any large files at that point).

You could perhaps try different -O optimization levels.  Also
make sure your xlc is up-to-date.

			regards, tom lane