HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlCritical

How to restart PostgreSQL server under CentOS 7

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
postgresqlcentosrestartunderhowserver

Problem

I installed PostgreSQL 10.1 under a CentOS 7.3 environment.

The service is started (postmaster.pid file present under /var/lib/pgsql/10/data), but I need to reload configuration or restart the server following a change in pg_hba.conf.

However, trying different commands, I get the following:

pg_ctl reload -D /var/lib/pgsql/10/data
bash: pg_ctl: command not found

service postgresql reload
Redirecting to /bin/systemctl reload postgresql.service
Failed to reload postgresql.service: Unit not found.

Solution

I found out that you need to specify the exact name for the PostgreSQL service, which you can find under the list of services, using systemctl (also see this post):

systemctl list-units|grep postgresql
postgresql-10.service                                                                     loaded active running   PostgreSQL 10 database server


Then you can use service:

service postgresql-10.service reload


or

service postgresql-10.service restart


Alternatively, you can use the systemctl command:

/bin/systemctl reload postgresql-10.service


or

/bin/systemctl restart postgresql-10.service

Code Snippets

systemctl list-units|grep postgresql
postgresql-10.service                                                                     loaded active running   PostgreSQL 10 database server
service postgresql-10.service reload
service postgresql-10.service restart
/bin/systemctl reload postgresql-10.service
/bin/systemctl restart postgresql-10.service

Context

StackExchange Database Administrators Q#196931, answer score: 55

Revisions (0)

No revisions yet.