Postgresql not started because of missing pg_hba.conf

UCS - Univention Corporate Server
1

Today, I was preparing my environment to update from 5.0-10 to 5.2. One of the post-update steps is to update postgresql 11 to version 15 (link)

Upon checking my current version, i noticed postgresql is not running on my primary node.

In the logs, I read the following:

2026-02-09 16:31:31.574 CET [840] LOG: could not open configuration file “/etc/postgresql/11/main/pg_hba.conf”: File or directory does not exist.
2026-02-09 16:31:31.574 CET [840] FATAL: could not load pg_hba.conf

This seems already to be the case since the installation of this server. On my backup directory node & managed node the postgresql server is missing completely (only the client is present).

My questions:

  • Is this missing postgresql service bad for my environment?
  • How can i re-create this pg_hba.conf file + are there any follow-up steps?
  • Is it normal that my backup node does not have a postgresql server?

Thanks for the help in advance

2

I managed to get the postgresql database up & running by manually creating a pg_hba.conf & pg_ident.conf file.

It turned out only the default databases were created so possibly this was a leftover from an app that i’ve installed but no longer present. I opted to remove postgresql-11 before performing the upgrade


                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
 postgres  | postgres | UTF8     | nl_BE.UTF-8 | nl_BE.UTF-8 |
 template0 | postgres | UTF8     | nl_BE.UTF-8 | nl_BE.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 template1 | postgres | UTF8     | nl_BE.UTF-8 | nl_BE.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres