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:20:53 +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]>
	<[email protected]>

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

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