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

ubuntu ubuntu-12.04 postgresql-9.1
yaron picture yaron · May 13, 2013 · Viewed 179.8k times · Source

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.

Answer

Ali picture Ali · Dec 14, 2018

On Ubuntu 18.04:

sudo systemctl restart postgresql.service

Related questions

How to install python3 version of package via pip on Ubuntu?

I have both python2.7 and python3.2 installed in Ubuntu 12.04. The symbolic link python links to python2.7. When I type: sudo pip install package-name It will default install python2 version of package-name. Some package supports both python2 and python3. How to …

Read More
sh: 0: getcwd() failed: No such file or directory on cited drive

I am trying to compile ARM code in Ubuntu 12. Everything is working fine when I put the code in the local directory. But when I put the code in cited mount directory error shows up: making testXmlFiles sh: 0: getcwd() failed: …

Read More
wget: unable to resolve host address `http'

I am getting this strange thing on my Ubuntu 12.04 64-bit machine when I do a wget $ wget google.com --2014-07-18 14:44:32-- http://google.com/ Resolving http (http)... failed: Name or service not known. wget: unable to resolve host …

Read More