Thread: my postgres.init file

my postgres.init file

From
"Vance Greenway"
Date:
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?

Re: [ADMIN] my postgres.init file

From
Terry Mackintosh
Date:
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!


Re: [ADMIN] my postgres.init file

From
Benjamin Gonay
Date:
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 !!!!!  _/
---------------------------------------------------------------------------