Ububtu 22.04 Server
Doug Easterbrook
doug at artsman.com
Sun Feb 25 15:26:37 UTC 2024
hi Chris.
I think the phrase ‘permission denied’ is the clue good clue in
> "/etc/postgresql/14/main/pg_hba.conf": Permission denied
it means the postgres server processes cannot read it, and so wont start up.
Postges typically requires that it run under a non priveledged user id. (at least, its that way on mac and widows). Since mac = unix, the inference is you can’t run postgres as a super user.
that means ownership and permission to access those files must be correct all along the pathway.
I’d check that the postgres user (or everyone) has read access to /etc. and within that the appropriate directories and sub directories
I’ve seen this in the past. On linux, the config directories and database directories are often separated into different place, by convention.
Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at artsman.com
http://www.artsman.com
Phone (403) 650-1978
> On Feb 24, 2024, at 3:54 PM, Chris Hughes via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
>
> 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
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
More information about the omnisdev-en
mailing list