starting the server at boot
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?
(I should be able to automatically pass a password, and I don't know how)
Thanks and regards
Javier Garcia
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