BUG #16829: Postgresql-12 service is not starting with SSL enabled in centos 7

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

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:      [hidden email]
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.

Reply | Threaded
Open this post in threaded view
|

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 <[hidden email]> 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