Search code examples
startuppostgresql-9.3

PostgreSQL 9.3 How to set start-type to manual on Ubuntu?


my psql9.3 server is starting every time I turn on my computer. I've heard that it can make your computer slower so I'd like to start postgresql service on demand only.

According to this website it's quite simple to do on Windows but I can't see such option for Linux. I have also read here that if you want to set your start-type to auto on Linux you can

"Copy the file start-scripts/linux from PostgreSQL's contrib directory to /etc/rc.d/init.d/postgresql and then Execute the command /sbin/chkconfig".

So is it good idea to remove that file to switch on manual type?


Solution

  • First of all, if PostgreSQL is idle it takes less CPU time than your mouse does. It may take some ram, but unless you are trying to run your computer without any GUI (shell prompt only) and have less than 1 GB this will be negligible.

    If you feel you have to manually start PostgreSQL, you can always do the procedure you have listed in your question. Do a backup first and be prepared to reinstall PostgreSQL should everything go wrong.