Date: Fri, 13 Sep 2024 16:15:59 +0200
From: =?iso-8859-1?Q?Fran=E7ois?= SIMON <francois.simon@free.fr>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, pgsql-general@postgresql.org
Subject: Re: post-bootstrap init : permission denied pg_description
Message-ID: <ZuRJHwbOu/wqvkgA@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>
 <4039017.1726162691@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <4039017.1726162691@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/ZuRJHwbOu/wqvkgA%40corindon.frsi.fr>
Precedence: bulk

Le Thu, Sep 12, 2024 at 01:38:11PM -0400, Tom Lane a écrit :
> =?iso-8859-1?Q?Fran=E7ois?= 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=hornet&dt=2024-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=1, 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.

Thank you for all this information.

Unfortunately I haven't obtained any better results yet.

I tried -O2, -O3, with or without -D_LARGE_FILES=1, xlc_r instead
of xlc, and all the same flags as the buildfarm member.

I will try with another version of xlc if possible.

François

> 
> 			regards, tom lane