Date: Thu, 12 Sep 2024 19:20:53 +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: <ZuMi9d9OetT0wPVJ@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>
 <49204586-6b6b-45aa-bc7a-671c67478aba@aklaver.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <49204586-6b6b-45aa-bc7a-671c67478aba@aklaver.com>
Archived-At: <https://www.postgresql.org/message-id/ZuMi9d9OetT0wPVJ%40corindon.frsi.fr>
Precedence: bulk

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