postgres, ubuntu how to restart service on startup? get stuck on clustering after instance reboot

Question

I have a Postgres db 9.1 running on AWS EC2, with ubuntu 12.04.

I messed a lot with the instance (i.e installed all kinds of postgres X.X before i settled on 9.1).

Now after a month working on that db, I discovered that if I restart my instance postgres doesn't load correctly, its status says "Running clusters". this will last forever until I

sudo service postgresql restart

from terminal, and then it works again.

How do I add this line, to ubuntu startup so that each time it loads, it will restart this service, and hopefully solve my problem?

Also any other solution which might solve this.

If you came here by google (like me) looking for the command to restart postgresql, in my case it was service postgresql-9.3 restart — Albert Hendriks, Jun 12 '15 at 11:17
I made Albert's comment a Question and Answer: https://stackoverflow.com/questions/52610485/how-to-restart-postgresql-in-ubuntu-18-04/52610486 — Ismail Yavuz, Oct 02 '18 at 14:28
Came just to get that restart command, got what I want, thanks — Ayoub Laazazi, Dec 03 '18 at 10:56

score 44 · Answer 1 · answered Dec 14 '18 at 13:24

44

On Ubuntu 18.04:

sudo systemctl restart postgresql.service

answered Dec 14 '18 at 13:24

Ali

6,808
3
37
47

You need to provide the cluster version as well: sudo systemctl start postgresql-9.5.service – Rajan Verma - Aarvy Dec 24 '19 at 05:23
@Aarvy strangely, on Ubuntu 20 with Postrges 13, the version isn't needed for systemctl – Michael B. Apr 18 '21 at 19:43

score 15 · Answer 2 · answered Mar 17 '20 at 11:40

15

The below command worked for me

sudo service postgresql restart

answered Mar 17 '20 at 11:40

Shahid Hussain Abbasi

2,508
16
10

Worked for me on Ubuntu 22.04, via WSL 2 on Windows – Matt Kleinsmith Dec 26 '22 at 21:03

score 9 · Answer 3 · edited Jun 20 '20 at 09:12

9

ENABLE is what you are looking for

USAGE: type this command once and then you are good to go. Your service will start automaticaly at boot up

 sudo systemctl enable postgresql

DISABLE exists as well ofc

Some DOC: freedesktop man systemctl

edited Jun 20 '20 at 09:12

Community

1
1

answered Dec 05 '19 at 15:27

Nathan Smiechowski

356
4
11

maybe i think this is for enable.... – CHAVDA MEET Oct 30 '21 at 11:02
@CHAVDAMEET the question was **How do I add this line, to ubuntu startup so that each time it loads, it will restart this service, and hopefully solve my problem?** – Nathan Smiechowski Nov 02 '21 at 14:18

score 7 · Accepted Answer · edited Apr 22 '16 at 12:31

7

I guess it would be best to fix the database startup script itself. But as a work around, you can add that line to /etc/rc.local, which is executed about last in init phase.

edited Apr 22 '16 at 12:31

Tombart

30,520
16
123
136

answered May 13 '13 at 09:53

TeTeT

2,044
20
30

thanks, but either that rc.local is not running, or the command executed before whatever postgres is doing, or the db overrides it somehow, il look into the logs for info, but off the bat that does not work. – yaron May 13 '13 at 16:08
Maybe there is a race condition, so rc.local gets executed before the regular postgres start process is finished, probably due to the error. Maybe you can add a sleep before the restart and see if that is a valid work around. – TeTeT May 14 '13 at 12:17
thanks the rc was the right directions, i found the solution in the rcX files. which govern the startup order – yaron May 15 '13 at 07:18

score 6 · Answer 5 · answered Oct 30 '21 at 11:01

6

restart postgresql

$ sudo service postgresql restart

answered Oct 30 '21 at 11:01

CHAVDA MEET

777
8
14

score 1 · Answer 6 · answered Feb 08 '22 at 05:08

1

for ubuntu startup so that each time it loads, it will restart this service of Postgres on startup so that you won't have to restart it all the time

sudo update-rc.d postgresql enable

answered Feb 08 '22 at 05:08

CHAVDA MEET

777
8
14

postgres, ubuntu how to restart service on startup? get stuck on clustering after instance reboot

6 Answers6

ENABLE is what you are looking for

restart postgresql

Linked