cannot access ' /tmp/.s.PGSQL.5432': No such file or directory while psql works #20
Description
Hello,
I've got an unexepected error - psql works:
[postgres@pgsql-cat-rdb-1 ~]$ psql -h /tmp -c "select version()"
version
----------------------------------------------------------------------------------------------------------
PostgreSQL 17.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-5), 64-bit
(1 row)
[postgres@pgsql-cat-rdb-1 ~]$ ls -Zl /tmp/.s.PGSQL.5432
srwxrwxrwx. 1 postgres postgres system_u:object_r:tmp_t:s0 0 Nov 14 15:19 /tmp/.s.PGSQL.5432
[postgres@pgsql-cat-rdb-1 ~]$ pgdsat -o report.html -D /pgsql/cluster/17/data
ls: cannot access ' /tmp/.s.PGSQL.5432': No such file or directory
Died at /usr/share/perl5/vendor_perl/PGDSAT.pm line 1612.
postgres=# show unix_socket_directories ;
unix_socket_directories
-------------------------
/run/postgresql, /tmp
(1 row)
OS: AlmaLinux9, PG17.6, all installed from rpm (inc. pgdsat).
I had to add binaries to path - this resolves following errror:
FATAL: command pg_controldata is not available from environment variable $PATH
Do I miss some setting?
Kind regards Ales Zeleny