Обсуждение: BUG #16829: Postgresql-12 service is not starting with SSL enabled in centos 7
BUG #16829: Postgresql-12 service is not starting with SSL enabled in centos 7
От
PG Bug reporting form
Дата:
The following bug has been logged on the website: Bug reference: 16829 Logged by: Bibhu Sahoo Email address: bibhu791@gmail.com PostgreSQL version: 12.5 Operating system: linux centos 7 Description: We observed below two issues in centos 7. 1: We used 3 postgres12 rpms (postgresql12-12.5-1PGDG.rhel7.x86_64.rpm, postgresql12-libs-12.5-1PGDG.rhel7.x86_64.rpm, postgresql12-server-12.5-1PGDG.rhel7.x86_64.rpm). By default ssl was 'off' in postgresql.conf. when we tried starting postgres service getting status like 'activating (start)' and 'Starting PostgreSQL 12'. This is not becoming to 'active and started'. But able to connect to postgres db. Output as below. [root@space-000c2932ed49 RPMS]# systemctl status postgresql-12 \u25cf postgresql-12.service - PostgreSQL 12 database server Loaded: loaded (/usr/lib/systemd/system/postgresql-12.service; enabled; vendor preset: disabled) Active: activating (start) since Mon 2021-01-18 12:28:26 UTC; 25s ago Docs: https://www.postgresql.org/docs/12/static/ Process: 11236 ExecStartPre=/usr/pgsql-12/bin/postgresql-12-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS) Main PID: 11242 (postmaster) Tasks: 8 CGroup: /system.slice/postgresql-12.service \u251c\u250011242 /usr/pgsql-12/bin/postmaster -D /var/lib/pgsql/12/data/ \u251c\u250011244 postgres: logger \u251c\u250011246 postgres: checkpointer \u251c\u250011247 postgres: background writer \u251c\u250011248 postgres: walwriter \u251c\u250011249 postgres: autovacuum launcher \u251c\u250011250 postgres: stats collector \u2514\u250011251 postgres: logical replication launcher Jan 18 12:28:26 space-000c2932ed49 systemd[1]: Starting PostgreSQL 12 database server... [root@space-000c2932ed49 RPMS]# 2: We changed ssl=off to ssl=on in postgresql.conf file and also added ssl ciphers. When we tried to start the postgres service, postgres service is not starting and showing the below error. [root@space-000c2932ed49 data]# systemctl status postgresql-12 \u25cf postgresql-12.service Loaded: not-found (Reason: No such file or directory) Active: failed (Result: exit-code) since Mon 2021-01-18 12:53:23 UTC; 12min ago Main PID: 15357 (code=exited, status=1/FAILURE) Jan 18 12:53:23 space-000c2932ed49 systemd[1]: Starting PostgreSQL 12 database server... Jan 18 12:53:23 space-000c2932ed49 systemd[1]: postgresql-12.service: main process exited, code=exited, status=1/FAILURE Jan 18 12:53:23 space-000c2932ed49 systemd[1]: Failed to start PostgreSQL 12 database server. Jan 18 12:53:23 space-000c2932ed49 systemd[1]: Unit postgresql-12.service entered failed state. Jan 18 12:53:23 space-000c2932ed49 systemd[1]: postgresql-12.service failed. [root@space-000c2932ed49 data]# Didn't observe any error in postgres log.
Re: BUG #16829: Postgresql-12 service is not starting with SSL enabled in centos 7
От
Juan José Santamaría Flecha
Дата:
On Mon, Jan 18, 2021 at 7:45 PM PG Bug reporting form <noreply@postgresql.org> wrote:
[root@space-000c2932ed49 data]# systemctl status postgresql-12
\u25cf postgresql-12.service
Loaded: not-found (Reason: No such file or directory)
This points to a missing call to: 'systemctl --user daemon-reload'
Regards,
Juan José Santamaría Flecha