How to restart PostgreSQL in Ubuntu 18.04

Question

How to restart PostgreSQL via ssh console?

Most likely you'll find better results on [dba.se] where this question belongs. — Filburt, Oct 02 '18 at 14:31
Thank you Filburt. I've voted to close to move it dba site. I've checked there is no answer to this question in dba site too. — Ismail Yavuz, Oct 02 '18 at 18:26

score 128 · Accepted Answer · answered Oct 02 '18 at 14:27

128

sudo service postgresql restart

answered Oct 02 '18 at 14:27

Ismail Yavuz

score 12 · Answer 2 · edited Oct 11 '20 at 00:07

12

systemctl restart postgresql@<postgres_version>-<cluster_name>.service

By default cluster_name = 'main', run this command to list all the clusters you have :

ls /var/lib/postgresql/

if you want to know whether the postgresql is running try this command :

systemctl status postgresql@<postgres_version>-<cluster_version>.service

edited Oct 11 '20 at 00:07

aarona

answered Oct 02 '18 at 15:24

aziz aziz

1

There seems to be two daemons around `postgresql` and `postgresql@XX-main` any idea or reference to what's the difference? – lowercase00 Mar 29 '22 at 20:35

score 7 · Answer 3 · answered Sep 03 '19 at 11:15

7

My postgresql service is named postgresql-9.5; in case you get "postgresql: unrecognized service" you can find its name with

sudo service --status-all | grep postgresql

and then proceed as per the accepted answer.

answered Sep 03 '19 at 11:15

JL_SO

I got this awk: fatal: cannot open file `/etc/mongod.conf' for reading (No such file or directory) – Rajan Verma - Aarvy Dec 24 '19 at 04:50
@Aarvy, were you running the command as sudo? There is a reference to mongod.conf in your /etc/init.d/mongod file. Regardless of this you can also run this command to see the name of your postgres service: `ls -lrt /etc/init.d/postgres*` – JL_SO Jan 24 '20 at 15:43

score 0 · Answer 4 · answered May 21 '22 at 07:58

The problem is with your remote configuration

sudo nano /etc/postgresql/13/main/postgresql.conf

Uncomment line 59 and change the Listen address to accept connections within your networks. *

#Listen on all interfaces

listen_addresses = '*'

#Listen on specified private IP address

listen_addresses = '192.168.10.11`

4 Answers4