Re: [ADMIN] my postgres.init file

From: Benjamin Gonay <us066182(at)ltlg1(dot)is(dot)belgacom(dot)be>
To: Vance Greenway <vance(at)ricochet(dot)net>
Cc: pgsql-admin(at)postgreSQL(dot)org
Subject: Re: [ADMIN] my postgres.init file
Date: 1999-01-10 09:42:29
Message-ID: Pine.LNX.3.96.990110103745.23656A-100000@ltlg1.bc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(dot)Gonay(at)ltlg1(dot)is(dot)belgacom(dot)be _/
_/ ~~ Soyons realistes, exigeons l'impossible. (E. Che Guevara) ~~ _/
_/ - - [Belgium - Liege] - - - - - - - - - - - - - - - - - - - - - - - _/
_/ linux forever...Linux Forever...LINUX Forever...LINUX FOREVER !!!!! _/
---------------------------------------------------------------------------

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Terry Mackintosh 1999-01-10 13:28:40 Re: [ADMIN] my postgres.init file
Previous Message Francisco Javier 1999-01-10 06:31:03 Data dir