Re: post-bootstrap init : permission denied pg_description

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