Restart PostgreSQL without postgresql-server

Question

I'm on CentOS 7 and I'm trying to get through the 'PG::ConnectionBad: FATAL: Peer authentication failed for user' error.

So I've already figured out that I should change pg_hba.conf (peer to md5) and I've done it. It seems that I have to restart postgres but it is not so easy as I thought.

I tried 'service postgresql restart' which resulted in 'Failed to restart postgresql.service: Unit not found.'

Then tried to install posgresql-server. Got:

oct 23 01:16:15 serverct1 pg_ctl[3280]: HINT:  Is another postmaster already running on port 5432? If ...try.
oct 23 01:16:15 serverct1 pg_ctl[3280]: WARNING:  could not create listen socket for "localhost"
oct 23 01:16:15 serverct1 pg_ctl[3280]: FATAL:  could not create any TCP/IP sockets
oct 23 01:16:16 serverct1 pg_ctl[3280]: pg_ctl: could not start server
oct 23 01:16:16 serverct1 systemd[1]: postgresql.service: control process exited, code=exited status=1
oct 23 01:16:16 serverct1 systemd[1]: Failed to start PostgreSQL database server.

About 5432 port usage:

postgres        5432/tcp        postgresql      # POSTGRES
postgres        5432/udp        postgresql      # POSTGRES

So I'm curious:

1) Do postgresql and postgresql-server work separately?

2) Is it possible to restart posgresql without postgresql-server?

3) If not - how to get the port 5432 free in order to run postgresql-server?

try pg_ctl reload, and yes - hba_conf changes requires reload, not restart — Vao Tsun
– Vao Tsun, Commented Oct 23, 2017 at 7:27

Vao Tsun · Accepted Answer · 2017-10-23 09:05:21Z

2

You can avoid troubles with serverct1 if you use standard postgres pg_ctl, eg:

pg_ctl reload

Or if needed pg_ctl reload -D $PGDATA

You dont need to restart the postgres for pg_hba changes to apply: https://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html

The pg_hba.conf file is read on start-up and when the main server process receives a SIGHUP signal. If you edit the file on an active system, you will need to signal the postmaster (using pg_ctl reload or kill -HUP) to make it re-read the file.

answered Oct 23, 2017 at 9:05

Vao Tsun

52.5k13 gold badges114 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Restart PostgreSQL without postgresql-server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related