Re: Autostart PostgreSQL in Ubuntu

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Carlos Moreno <moreno_pg(at)mochima(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Autostart PostgreSQL in Ubuntu
Date: 2007-09-26 17:52:38
Message-ID: 46FA9C66.4080409@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Carlos Moreno wrote:
> Johann Maar wrote:
>> But if I try to start PostgreSQL by running "sudo /etc/init.d/
>> postgresql start" it will fail because it tries to write a PID file to
>> "/var/run/postgresql" which does not exist. If I create this directory
>> and set the permissions for postgres to write it works (!), but after
>> the next restart of the machine the directory is already gone.
>
> With Red Hat systems, you would do chkconfig postgresql on if you
> installed
> the postgresql that they distribute.
>
> On Ubuntu (and I imagine with all Debian-based systems), AFAIK you have
> to manually adjust the init scripts for the runlevels that you want.
> Assuming

You can use update-rc.d.

Joshua D. Drake
- --

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFG+pxmATb/zqfZUUQRAmHeAJ9DhNAHqrM+lYeCwYeSH+WOfVkHDgCdGlyN
/mKS9XFfGJTM2HkctVTURsM=
=hBY/
-----END PGP SIGNATURE-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gowrishankar 2007-09-26 18:58:38 Data cube in PostgreSQL
Previous Message Tom Lane 2007-09-26 17:15:31 Re: More on migragting the server.