public inbox for [email protected]
help / color / mirror / Atom feedFrom: Pierre Juhen <[email protected]>
To: [email protected]
Subject: Re: BUG #19502: unix_socket_group doesn't work anymore
Date: Sun, 31 May 2026 18:47:03 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
Please forget this stupid question.
I forgot a usermod to allow postgres to be in the palin user group
Shame on me.
Pierre
Le 31/05/2026 à 16:41, PG Bug reporting form a écrit :
> The following bug has been logged on the website:
>
> Bug reference: 19502
> Logged by: Pierre Juhen
> Email address:[email protected]
> PostgreSQL version: 16.3
> Operating system: Linux
> Description:
>
> Hi,
>
> I developped an application on Alma Linux 9 and PostgreSQL 13.
>
> I want to maintain it up to date, and try to "port" it to Alma Linux 10 and
> PostgreSQL 16.13
>
> Previously the appplication run under the identity of a plain user. The Unix
> socket (/var/run/postgresql/.s.PGSQL.5432) was owned by postgres and the
> group was that plain user one.
>
> Now, postgreSQL refuses to launch with the following error :
>
> 2026-05-30 23:59:27.178 CEST [5163] LOG: n'a pas pu initialiser le groupe
> du fichier « /var/run/postgresql/.s.PGSQL.5432 » : Opération non permise
> 2026-05-30 23:59:27.178 CEST [5163] ATTENTION: n'a pas pu créer la socket
> de domaine Unix dans le répertoire « /var/run/postgresql »
> 2026-05-30 23:59:27.180 CEST [5163] LOG: n'a pas pu initialiser le groupe
> du fichier « /tmp/.s.PGSQL.5432 » : Opération non permise
> 2026-05-30 23:59:27.180 CEST [5163] ATTENTION: n'a pas pu créer la socket
> de domaine Unix dans le répertoire « /tmp »
> 2026-05-30 23:59:27.180 CEST [5163] FATAL: n'a pas pu créer les sockets de
> domaine Unix
>
> Translated by google in english :
>
> 2026-05-30 23:59:27.178 CEST [5163] LOG: Could not initialize the group for
> the file '/var/run/postgresql/.s.PGSQL.5432': Operation not permitted
> 2026-05-30 23:59:27.178 CEST [5163] WARNING: Could not create the Unix
> domain socket in the directory '/var/run/postgresql'
> 2026-05-30 23:59:27.180 CEST [5163] LOG: Could not initialize the group for
> the file '/tmp/.s.PGSQL.5432': Operation not permitted
> 2026-05-30 23:59:27.180 CEST [5163] WARNING: Could not create the socket
> Unix domain in the "/tmp" directory
> 2026-05-30 23:59:27.180 CEST [5163] FATAL: Could not create Unix domain
> sockets
>
> If I comment unix_socket_group in postgresql.conf, the system starts without
> any problem.
>
> The postgres heading process has got the right chown capability (cap_chown)
>
> I don't undestand what append.
>
> The same problem occurs with my development machine (Fedora 44 and and
> PostgreSQL 18.3).
>
> Recent changes in the kernel ?
>
> Any help would be welcome.
>
> Thanks,
>
> Pierre
>
>
view thread (2+ messages)
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: BUG #19502: unix_socket_group doesn't work anymore
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