Search Postgresql Archives

Re: post-bootstrap init : permission denied pg_description

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux