Re: pgadmin4 on Ubuntu

Il giorno mer 21 set 2022 alle ore 07:51 Yogesh Mahajan <
yogesh(dot)mahajan(at)enterprisedb(dot)com> ha scritto:

> Hi,
>
> Can you please try connecting postgres via psql? You might need to update
> the postgres setting mentioned over here
> <https://syntaxfix.com/question/4987/postgresql-why-psql-can-t-connect-to-server>
> .
> Once you are able to connect with psql via terminal, you should be able to
> connect using pgAdmin too.
>
> Thanks,
> Yogesh Mahajan
> EnterpriseDB
>
>
>

Thanks for your reply

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(at)14-main(dot)service - PostgreSQL Cluster 14-main
Loaded: loaded (/lib/systemd/system/postgresql(at)(dot)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(at)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(at)14-main[976]: 2022-09-21 07:08:45.377
CEST [1116] LOG: peer authentication i>
set 21 07:08:45 me-laptop postgresql(at)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(at)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(at)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(at)14-main[976]: pg_ctl: could not start
server
set 21 07:08:45 me-laptop postgresql(at)14-main[976]: Examine the log output.
set 21 07:08:45 me-laptop systemd[1]: postgresql(at)14-main(dot)service: Can't
open PID file /run/postgresql/14-main.pid >
set 21 07:08:45 me-laptop systemd[1]: postgresql(at)14-main(dot)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