Thread: my postgres.init file
when i execute my posgres.init file, it asks for a password per the su command that is in it, but does not pause for a password to be entered and consequently cannot launch the postmaster. is there an obvious fix, or even an obscure one to help this newbie out?
Hi Vance On Sat, 9 Jan 1999, Vance Greenway wrote: > when i execute my posgres.init file, it asks for a password per the su > command that is in it, but does not pause for a password to be entered > and consequently cannot launch the postmaster. is there an obvious fix, > or even an obscure one to help this newbie out? That file is ment to be run at boot time, that is, to be run as root. Are you trying to run it as other then root or postgres? Have a great night, home that helps Terry Mackintosh <terry@terrym.com> http://www.terrym.com sysadmin/owner Please! No MIME encoded or HTML mail, unless needed. Proudly powered by R H Linux 4.2, Apache 1.3.x, PHP 3.x, PostgreSQL 6.x ----------------------------------------------------------------------- Success Is A Choice ... book by Rick Pitino, get it, read it!
Hi Vance, To start the postmaster, at startup, as root, do : su - postgres -c "postmaster ......" (with your needed options) This doesn't need any password, as it's root which start your script instead of (really) an other user, here the 'postgres' user account. Be carefull to NOT FORGET the 'postgres' after the 'su -' , else the postmaster will start us root, which is very bad for the database security. Hope this help you... Cybersalutations. Benjamin Gonay --------------------------------------------------------------------------- _/ Email internet : Benjamin.Gonay@ltlg1.is.belgacom.be _/ _/ ~~ Soyons realistes, exigeons l'impossible. (E. Che Guevara) ~~ _/ _/ - - [Belgium - Liege] - - - - - - - - - - - - - - - - - - - - - - - _/ _/ linux forever...Linux Forever...LINUX Forever...LINUX FOREVER !!!!! _/ ---------------------------------------------------------------------------