Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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.

like image 398
yaron Avatar asked May 13 '13 06:05

yaron


People also ask

How do I make sure Postgres is running?

basically just type "systemctl status postgresql-xx" where xx is the version of your PostgreSQL instance. ex: systemctl status posgresql-10.


3 Answers

On Ubuntu 18.04:

sudo systemctl restart postgresql.service

like image 151
Ali Avatar answered Nov 18 '22 22:11

Ali


The below command worked for me

sudo service postgresql restart

like image 39
Shahid Hussain Abbasi Avatar answered Nov 18 '22 22:11

Shahid Hussain Abbasi


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.

like image 7
TeTeT Avatar answered Nov 18 '22 22:11

TeTeT