Home / ubuntu / Questions / 154271
In Process
Homunculus Reticulli
Asked: 2012-06-22 10:08:59 +0800 CST

How do I start the postgreSQL service upon boot?

  • 772

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:

  1. Stop the currently running PG service
  2. 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?

10.04

1 Answers

  1. You should edit the file postgresql.conf. Where to find this file and a lot of other information can be found in postgresql's manual (18.1 and 18.2).

    On my system (natty) this file is in /etc/postgresql/8.4/main. The variable you have to change is data_directory.

    • 1