I have droplet running Ubuntu 14.04 with preconfigured postgresql, rails and nginx. I am running apt-get upgrade when necessary and all worked fine until today when I saw in console that reboot is required. After reboot I found out that my init.d scripts for postgresql are not runing. They show OK for start, or stop but service actually is not started or stoped. I have to manually execute postgres what is not suitable. Could you help my why this happened and how to update init.d script for postgres 9.6 ? thanks
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
This comment has been deleted
I upgraded postgres from default repo, didnt use any other. Later I found that I had installed already postgres 10, so when I upgraded my pgcluster to 10 it started to work. But later, I forgot to remove old postgres install files and after their upgrade, it is not working again. I did test like 10 minutes ago, service postgresql stop/start did nothing, I have to run it manually with pg_ctl command
this is my init script
The version of Postgresql shipped on the Rails One-Click application is the default version from the Ubuntu repositories. No custom init script is used. By default Ubuntu 14.04 ships Postgresql 9.3. Have you installed installed a new version from a third-party repository? Can you share the init script and any relevant logs?