By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,834 Members | 2,234 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,834 IT Pros & Developers. It's quick & easy.

starting the server at boot

P: n/a
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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.