Stopping postgresql from starting on ubuntu startup

Question

Ubuntu 16.04.1 LTS I have tried:

sudo update-rc.d -f postgresql remove

and

sudo vim /etc/postgresql/9.5/main/start.conf

then i change the word "auto" to "disabled"

Then i reboot the computer, and when it starts, i login and do:

sudo service --status-all | grep postgresql

Which returns:

[ + ]  postgresql

So it is still starting when the server starts. What is left for me to do? I don't want this service running when the computer starts, only when i manually start it with:

sudo service postgresql start

See the SystemD section here: askubuntu.com/questions/19320/how-to-enable-or-disable-services — Koen De Groote
– Koen De Groote, Commented Jan 8, 2017 at 1:40
Thank you. I don't know which solution fixed it, but it's fixed now. It won't let me mark a best answer. — asdf
– asdf, Commented Jan 8, 2017 at 1:59
Stack Overflow is a site for programming and development questions. This question appears to be off-topic because it is not about programming or development. See What topics can I ask about here in the Help Center. Perhaps Super User or Unix & Linux Stack Exchange would be a better place to ask. Also see Where do I post questions about Dev Ops? — jww
– jww, Commented Jan 8, 2017 at 20:08

g10guang · Accepted Answer · 2018-04-14 05:50:01Z

188

Use systemctl command to manage postgresql service:

stop service:

systemctl stop postgresql
start service:

systemctl start postgresql
show status of service:

systemctl status postgresql
disable service(not auto-start any more)

systemctl disable postgresql
enable service postgresql(auto-start)

systemctl enable postgresql

answered Apr 14, 2018 at 5:50

g10guang

5,4333 gold badges31 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Sussch Over a year ago

The service still auto-starts after a sudo systemctl disable postgresql@10-main. sudo service postgresql@10-main disable doesn't work, either. Perhaps editing /etc/postgresql/10/main/start.conf might do the trick.

Akhila Over a year ago

I tried disabling it.. but I'm getting a permission denied error.. @g10guang - need to add sudo!

davcli Over a year ago

It really helped me out. It works perfectly.

Derek Adair Over a year ago

on ubuntu 20.04.5 i needed to edit /etc/postgresql/[VERSION]/main/start.conf and change auto -> disabled

asdf · Accepted Answer · 2017-01-08 01:51:53Z

15

Ok. it's fixed thanks to Koen De Groote.

I did:

echo manual | sudo tee /etc/init/postgresql.override

and

sudo systemctl disable postgresql.service

and

sudo systemctl disable postgresql

....I don't know which one of them did it, but its not starting any more... Thank you...

answered Jan 8, 2017 at 1:51

asdf

1,0391 gold badge7 silver badges10 bronze badges

1 Comment

Syed Habib M Over a year ago

@asdf sudo systemctl disable postgresql this is enough.

Collectives™ on Stack Overflow

Stopping postgresql from starting on ubuntu startup

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related