Re: [Pgsqlrpms-hackers] Safer auto-initdb for RPM init

Andrew Dunstan <andrew@dunslane.net>

From: Andrew Dunstan <andrew@dunslane.net>
To: "Jim C. Nasby" <jnasby@pervasive.com>
Cc: Joe Conway <mail@joeconway.com>, pgsqlrpms-hackers@pgfoundry.org, pgsql-hackers@postgresql.org
Date: 2006-08-26T23:16:52Z
Lists: pgsql-hackers

Jim C. Nasby wrote:
> On Fri, Aug 25, 2006 at 07:21:50AM -0700, Joe Conway wrote:
>   
>> We also decided to turn off the init script execution entirely. The DBAs 
>> were more comfortable with a manual database startup for a production 
>> machine anyway (this is the way they typically handle Oracle databases 
>> also). They get paged if the server ever goes down unplanned, and in 
>> that event they like to check things out before bringing the db back up. 
>> For planned outages, database startup is simply part of the plan.
>>     
>
> I'd *really* like to have an official way to just disable the initdb
> code entirely.
>   

Well, in the case of RPMS built with the pgfoundry pgsqlrpms project 
init script, it looks to me like it is already disabled: see 
http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgsqlrpms/patches/8.2/postgresql.init?rev=1.2&content-type=text/x-cvsweb-markup

In the case of Redhat/Fedora supplied RPMs, presumably it is not 
disabled as a matter of policy, the idea being to make starting postgres 
as easy as possible. What you could do is to ask them to add some code 
to honor the setting of a variable called say, PG_INITDB, which you 
would set in the appropriate place in /etc/sysconfig.

cheers

andrew