Date: Thu, 12 Sep 2024 19:06:39 +0200
From: =?iso-8859-1?Q?Fran=E7ois?= SIMON <francois.simon@free.fr>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general@postgresql.org
Subject: Re: post-bootstrap init : permission denied pg_description
Message-ID: <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>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <ZuMQ44BSc4kpaBhK@corindon.frsi.fr>
Archived-At: <https://www.postgresql.org/message-id/ZuMfn0xPo91YJ%2Bao%40corindon.frsi.fr>
Precedence: bulk

Le Thu, Sep 12, 2024 at 06:03:47PM +0200, François SIMON a écrit :
> Le Thu, Sep 12, 2024 at 08:20:59AM -0700, Adrian Klaver a écrit :
> > On 9/12/24 03:58, François SIMON wrote:
> > > Hello All,
> > > 
> > > I am trying to install PostgreSQL 16.4 on AIX 7.1.
> > > 
> > > I get an error at initdb step :
> > > 
> > > performing post-bootstrap initialization ... 2024-09-12 12:09:07.075 CEST [14745748] FATAL:  permission denied for table pg_description
> > 
> > That looks like an issue with the user you are running the command as.
> > 
> > What user is that?
> 
> A normal user account.
> 

I think the environment is ok because it works with an initdb
built with gcc.

# ls -l /prod/postgresql
V16.3 -> V16.3-build_gcc
V16.3-build_gcc
V16.3-build_xlc

# initdb
Success. You can start the database...

# ln -sf V16.3-build_xlc /prod/postgresl/V16.3
V16.3 -> V16.3-build_xlc
V16.3-build_gcc
V16.3-build_xlc

# pg_ctl -l logfile start
server started

# psql -d template1
psql (16.3à
Type "help" for help.

template1=# \l
List of databases
Name
--------
postgres
template0
template1
...

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

François