How do I start the postgreSQL service upon boot?

Posted by Homunculus Reticulli on Ask Ubuntu See other posts from Ask Ubuntu or by Homunculus Reticulli
Published on 2012-06-21T18:08:59Z Indexed on 2012/06/21 21:23 UTC
Read the original article Hit count: 370

Filed under:

10.04

|

startup

|

service

|

postgresql

I am running PostgreSQL (v 8.4) on Ubuntu 10.0.4.

The PG service currently starts on reboot (after I installed PG on my machine), however, I want the service to use a new data directory.

Currently, after a reboot, I have to:

Stop the currently running PG service
manually type: /usr/local/pgsql/bin/pg_ctl start -D /my/preffered/data/directory -l /usr/local/pgsql/data/logfile

Which file do I need to edit to ensure that I always have the service using the correct data folder?

© Ask Ubuntu or respective owner

Related posts about 10.04

An increase to 3 Gig of RAM slows down Ubuntu 10.04 LTS

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I have Ubuntu 10.04 running from an external hard drive (installed on an enclosure) connected via USB port. Like a month or so ago, I increased RAM on my pc from 2 Gigs to 3 Gigs. This resulted on extremely long boot times and slow application loads. While I was understanding the nature of my problem… >>> More
Postgresql fails to start on Ubuntu 10.04.4 LTS

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I installed postgresql 9.2 from add-apt-repository ppa:pitti/postgresql using apt-get install postgresql-9.2 At the end of the install and every time I try to launch postgresql by using the following command /etc/init.d/postgresql start or service postgresql start I get this error: Error:… >>> More
SSH main process ended

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I have a running ubuntu server 10.04.1. When I tried to login to the server via ssh, I could not. Instead, I got connection refused error. I tried to ping the machine and I got reply! So, the clear reason is that SSH daemon is stopped. After reboot, I was able to login to my server via ssh. After… >>> More
Default /etc/apt/sources.list?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I need default source list for ubuntu 10.04. Can anybody help me? Here is Mine:--- Ubuntu supported packages deb http://archive.ubuntu.com/ubuntu/ lucid main restricted multiverse universe deb http://archive.ubuntu.com/ubuntu/ lucid-backports main restricted universe multiverse deb http://archive… >>> More
PPA causing 404 error?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I need default source list for ubuntu 10.04. Can anybody help me? Here is Mine:--- Ubuntu supported packages deb http://archive.ubuntu.com/ubuntu/ lucid main restricted multiverse universe deb http://archive.ubuntu.com/ubuntu/ lucid-backports main restricted universe multiverse deb http://archive… >>> More

Related posts about startup

SQL Navigator startup error: Unhandled Exception at startup - Cannot find OCI DLL: oci.dll

as seen on Server Fault - Search for 'Server Fault'
I am using 64 bits Windows 7. Oracle Development Tool: SQL Navigator 5.5 was installed on my computer. When I try to start the program I get this error: "Unhandled Exception at startup - Cannot find OCI DLL: oci.dll" Then I get this error: "Access violation at address 0101916B in module 'SQLNav5… >>> More
SQL Navigator startup error: Unhandled Exception at startup - Cannot find OCI DLL: oci.dll

as seen on Server Fault - Search for 'Server Fault'
I am using 64 bits Windows 7. Oracle Development Tool: SQL Navigator 5.5 was installed on my computer. When I try to start the program I get this error: "Unhandled Exception at startup - Cannot find OCI DLL: oci.dll" Then I get this error: "Access violation at address 0101916B in module 'SQLNav5… >>> More
Stuck on Checking battery state at startup in Ubuntu, have splash screen no startup

as seen on Super User - Search for 'Super User'
I am running Ubuntu 10.04 LTS. When I boot up the computer it goes to the splash but there is no login screen, just the purple background and the mouse cursor. "Checking battery state" is the last line that does not have an "[OK]". When I press Ctr-alt-shift-F1 I can login and sudo stop gdm and… >>> More
Disable ability to add startup items in Windows 7?

as seen on Super User - Search for 'Super User'
Note: This is not the question "How to disable startup items" because the simple answer is: "Use msconfig". Now as for my question: I recently am very annoyed that some programs add startup items to my PC without my knowledge after installation, I always have 2 programs which startup - Temperature… >>> More
Startup Broadcast Receiver Not Running At Startup

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a class StartupReceiver: public class StartupReceiver extends BroadcastReceiver { @Override public void onReceive(Context context, Intent intent) { Intent service = new Intent(context, ARMRService.class); context.startService(service); } and it is declared in my Manifest.xml as <receiver… >>> More