Il giorno mer 21 set 2022 alle ore 07:51 Yogesh Mahajan <yogesh.mahajan@xxxxxxxxxxxxxxxx> ha scritto:
Hi,Can you please try connecting postgres via psql? You might need to update the postgres setting mentioned over here.Once you are able to connect with psql via terminal, you should be able to connect using pgAdmin too.Thanks,Yogesh MahajanEnterpriseDB
pgsql fails to connect with the exact same error that pgadmin4 reports
The step 1 in the reply you linked fails
In fact, there's no postgres daemon running, it seems
I have this
$ sudo systemctl status 'postgresql*'
× postgresql@14-main.service - PostgreSQL Cluster 14-main
Loaded: loaded (/lib/systemd/system/postgresql@.service; enabled-runtime; vendor preset: enabled)
Active: failed (Result: protocol) since Wed 2022-09-21 07:08:45 CEST; 1h 0min ago
CPU: 68ms
set 21 07:08:45 me-laptop postgresql@14-main[976]: 2022-09-21 07:08:45.367 CEST [1116] LOG: listening on Unix soc>
set 21 07:08:45 me-laptop postgresql@14-main[976]: 2022-09-21 07:08:45.377 CEST [1116] LOG: peer authentication i>
set 21 07:08:45 me-laptop postgresql@14-main[976]: 2022-09-21 07:08:45.377 CEST [1116] CONTEXT: line 97 of config>
set 21 07:08:45 me-laptop postgresql@14-main[976]: 2022-09-21 07:08:45.377 CEST [1116] FATAL: could not load pg_h>
set 21 07:08:45 me-laptop postgresql@14-main[976]: 2022-09-21 07:08:45.378 CEST [1116] LOG: database system is sh>
set 21 07:08:45 me-laptop postgresql@14-main[976]: pg_ctl: could not start server
set 21 07:08:45 me-laptop postgresql@14-main[976]: Examine the log output.
set 21 07:08:45 me-laptop systemd[1]: postgresql@14-main.service: Can't open PID file /run/postgresql/14-main.pid >
set 21 07:08:45 me-laptop systemd[1]: postgresql@14-main.service: Failed with result 'protocol'.
set 21 07:08:45 me-laptop systemd[1]: Failed to start PostgreSQL Cluster 14-main.
● postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
Active: active (exited) since Wed 2022-09-21 07:08:45 CEST; 1h 0min ago
Main PID: 1194 (code=exited, status=0/SUCCESS)
CPU: 810us
set 21 07:08:45 me-laptop systemd[1]: Starting PostgreSQL RDBMS...
set 21 07:08:45 me-laptop systemd[1]: Finished PostgreSQL RDBMS.
× postgresql@14-main.service - PostgreSQL Cluster 14-main
Loaded: loaded (/lib/systemd/system/postgresql@.service; enabled-runtime; vendor preset: enabled)
Active: failed (Result: protocol) since Wed 2022-09-21 07:08:45 CEST; 1h 0min ago
CPU: 68ms
set 21 07:08:45 me-laptop postgresql@14-main[976]: 2022-09-21 07:08:45.367 CEST [1116] LOG: listening on Unix soc>
set 21 07:08:45 me-laptop postgresql@14-main[976]: 2022-09-21 07:08:45.377 CEST [1116] LOG: peer authentication i>
set 21 07:08:45 me-laptop postgresql@14-main[976]: 2022-09-21 07:08:45.377 CEST [1116] CONTEXT: line 97 of config>
set 21 07:08:45 me-laptop postgresql@14-main[976]: 2022-09-21 07:08:45.377 CEST [1116] FATAL: could not load pg_h>
set 21 07:08:45 me-laptop postgresql@14-main[976]: 2022-09-21 07:08:45.378 CEST [1116] LOG: database system is sh>
set 21 07:08:45 me-laptop postgresql@14-main[976]: pg_ctl: could not start server
set 21 07:08:45 me-laptop postgresql@14-main[976]: Examine the log output.
set 21 07:08:45 me-laptop systemd[1]: postgresql@14-main.service: Can't open PID file /run/postgresql/14-main.pid >
set 21 07:08:45 me-laptop systemd[1]: postgresql@14-main.service: Failed with result 'protocol'.
set 21 07:08:45 me-laptop systemd[1]: Failed to start PostgreSQL Cluster 14-main.
● postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
Active: active (exited) since Wed 2022-09-21 07:08:45 CEST; 1h 0min ago
Main PID: 1194 (code=exited, status=0/SUCCESS)
CPU: 810us
set 21 07:08:45 me-laptop systemd[1]: Starting PostgreSQL RDBMS...
set 21 07:08:45 me-laptop systemd[1]: Finished PostgreSQL RDBMS.
I don't understand what this means exactly
I need to investigate this further
If you have any suggestion about this, very appreciated
Thanks again
