AW: Ububtu 22.04 Server

[Stefan Csomor]

Hi 

The first lines “listening” of the startup seem perfectly fine 

0.0.0.0 just means listen on all available ipv4 ports (corresponding to a listen_address = ‘*’ in postgresql.conf instead of = ‘localhost’) 

>From https://www.postgresql.org/docs/current/runtime-config-connection.html <https://www.postgresql.org/docs/current/runtime-config-connection.html> 
«The special entry * corresponds to all available IP interfaces. The entry 0.0.0.0 allows listening for all IPv4 addresses and :: allows listening for all IPv6 addresses.” 

But this line is not ok, means it cannot read pg_hba.conf and has to shut down 

2024-02-25 09:47:52.513 AEST [3557] @/ LOG: could not open 
configuration file "/etc/postgresql/14/main/pg_hba.conf": Permission denied


Could it be you edited pg_hba.conf with a different user than postgres and now it has the wrong owner / group ? 

what does 

ls -l /etc/postgresql/14/main/pg_hba.conf 

say ? 

it should be postgres / postgres I think 

you could compare it to the permissions of the other pg_*.conf files in the dir, if these are postgres/postgres, a 

sudo chown postgres:postgres /etc/postgresql/14/main/pg_hba.conf 

should put things in order again 

just my 0.02$ 

Best, 

Stefan 

Von: omnisdev-en <omnisdev-en-bounces at lists.omnis-dev.com> im Auftrag von Chris Hughes via omnisdev-en <omnisdev-en at lists.omnis-dev.com>
Datum: Sonntag, 25. Februar 2024 um 00:54
An: omnisdev-en at lists.omnis-dev.com <omnisdev-en at lists.omnis-dev.com>
Cc: Chris Hughes <ataddata at bigpond.net.au>
Betreff: Ububtu 22.04 Server 

Here is the log


2024-02-25 09:47:52.508 AEST [3557] @/ LOG: starting PostgreSQL 14.11 
(Ubuntu 14.11-1.pgdg22.04+1) on x86_64-pc-linux-gnu, compiled by gcc 
(Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
2024-02-25 09:47:52.508 AEST [3557] @/ LOG: listening on IPv4 address 
"0.0.0.0", port 5432
2024-02-25 09:47:52.508 AEST [3557] @/ LOG: listening on IPv6 address 
"::", port 5432
2024-02-25 09:47:52.508 AEST [3557] @/ LOG: listening on Unix socket 
"/var/run/postgresql/.s.PGSQL.5432"
2024-02-25 09:47:52.513 AEST [3557] @/ LOG: could not open 
configuration file "/etc/postgresql/14/main/pg_hba.conf": Permission denied
2024-02-25 09:47:52.513 AEST [3557] @/ FATAL: could not load pg_hba.conf
2024-02-25 09:47:52.514 AEST [3557] @/ LOG: database system is shut down
pg_ctl: could not start server
Examine the log output.

Assume Line 2 is the problem, was working yesterday. Where do I fix.


-- 
*Chris Hughes*
Phone No:-07 32086347
Mobile No :- 0409 263 349
Email :- ataddata at bigpond.net.au
Address:-
3 Springwell Avenue
Springwood QLD 4127
_____________________________________________________________
Manage your list subscriptions at https://lists.omnis-dev.com <https://lists.omnis-dev.com>
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com <mailto:omnisdev-en at lists.omnis-dev.com>