Re: post-bootstrap init : permission denied pg_description - Mailing list pgsql-general

From François SIMON
Subject Re: post-bootstrap init : permission denied pg_description
Date
Msg-id ZuMi9d9OetT0wPVJ@corindon.frsi.fr
Whole thread Raw
In response to Re: post-bootstrap init : permission denied pg_description  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Le Thu, Sep 12, 2024 at 09:52:57AM -0700, Adrian Klaver a écrit :
> On 9/12/24 09:03, François SIMON wrote:
> > $HOME is on a NFS volume.
> 
> Have you read this?:
> 
> https://www.postgresql.org/docs/16/creating-cluster.html#CREATING-CLUSTER-FILESYSTEM

Yes. I understand NFS is OK, but yes I see some warnings.

> > selecting default time zone ... Europe/Paris
> > creating configuration files ... ok
> > running bootstrap script ... ok
> 
> Can you add the complete portion of the output that threw the error?

# initdb
The files belonging to this database system will be owned by user "fsi".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory /net/h10/home/fsi/data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Europe/Paris
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... 2024-09-12 17:38:35.580 CEST [9896122] FATAL:  permission denied for table
pg_description
2024-09-12 17:38:35.580 CEST [9896122] STATEMENT:
        WITH funcdescs AS ( SELECT p.oid as p_oid, o.oid as o_oid, oprname FROM pg_proc p JOIN pg_operator o ON oprcode
=p.oid ) INSERT INTO pg_description   SELECT p_oid, 'pg_proc'::regclass, 0,     'implementation of ' || oprname || '
operator'  FROM funcdescs   WHERE NOT EXISTS (SELECT 1 FROM pg_description    WHERE objoid = p_oid AND classoid =
'pg_proc'::regclass)  AND NOT EXISTS (SELECT 1 FROM pg_description    WHERE objoid = o_oid AND classoid =
'pg_operator'::regclass        AND description LIKE 'deprecated%');
 

child process exited with exit code 1
initdb: removing data directory "/net/h10/home/fsi/data"


François



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: post-bootstrap init : permission denied pg_description
Next
From: Tom Lane
Date:
Subject: Re: post-bootstrap init : permission denied pg_description