Re: starting the server at boot - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: starting the server at boot
Date
Msg-id 200311110535.53545.shridhar_daithankar@myrealbox.com
Whole thread Raw
In response to starting the server at boot  (javier garcia - CEBAS <rn001@cebas.csic.es>)
List pgsql-general
On Monday 10 November 2003 15:02, javier garcia - CEBAS wrote:
> Hello;
>
> If I add the line:
> -------------------
>  su -c 'pg_ctl start -D /usr/local/pgsql/data/ -l
> /usr/local/pgsql/data/logfile' postgres
> -------------------
> to /etc/rc.d/rd.local.
> Is there a way this could work when I don't boot as root, but as a common
> user?

rc.local script is always run as root. So it should work even if you boot/log
in as  normal user.

> (I should be able to automatically pass a password, and I don't know how)

Read man pages for .pgpass.

HTH

 Shridhar


pgsql-general by date:

Previous
From: "Mattias Kregert"
Date:
Subject: Re: Temp rows - is it possible?
Next
From: Rajesh Kumar Mallah
Date:
Subject: PL/PGSQL help for getting number of rows matched.