public inbox for [email protected]  

help / color / mirror / Atom feed

From: François SIMON <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: [email protected]
Subject: Re: post-bootstrap init : permission denied pg_description
Date: Thu, 12 Sep 2024 19:06:39 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <241898171.198702953.1726138710864.JavaMail.root@zimbra28-e5.priv.proxad.net>
	<[email protected]>
	<[email protected]>

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

view thread (9+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: post-bootstrap init : permission denied pg_description
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox