Re: initdb profiles - Mailing list pgsql-hackers

From Dave Page
Subject Re: initdb profiles
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E4CC2A95@ratbert.vale-housing.co.uk
Whole thread Raw
In response to initdb profiles  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: initdb profiles
List pgsql-hackers

> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of
> Andrew - Supernews
> Sent: 09 September 2005 08:16
> To: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] initdb profiles
>
> On 2005-09-08, Peter Eisentraut <peter_e@gmx.net> wrote:
> > Andrew - Supernews wrote:
> >> On 2005-09-08, Peter Eisentraut <peter_e@gmx.net> wrote:
> >> > Andrew - Supernews wrote:
> >> >> Running initdb behind the scenes is a proven dangerous practice
> >> >
> >> > Please elaborate.
> >>
> >> Example instance:
> >> http://archives.postgresql.org/pgsql-hackers/2004-12/msg00851.php
> >
> > If you run your database on NFS, your warranty is void.
>
> NFS has nothing to do with it.

Well, it sorta did in that case, but I see where you're coming from.
What does have something to do with it is that iirc it was the rc.pgsql
script that ran initdb in the background at boot time when it didn't
find the data directory, so perhaps your statement would be more
accurate as:

"Automatically running initdb behind the scenes at system startup is a
proven dangerous practice"

We've distributed hundreds of thousands of copies of pgInstaller which
initdb's behind the scenes and never had any reported problems.

Regards, Dave


pgsql-hackers by date:

Previous
From: "Paolo Magnoli"
Date:
Subject: R: Rendezvous/Bonjour broken in 8.1 beta
Next
From: Simon Riggs
Date:
Subject: Re: statement logging / extended query protocol issues