Re: initdb change

On Mon, 25 Aug 2008 13:56:16 -0400
Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:

> >
> > That is what I was suggesting.
> >

>
> Why should the xlog directory be treated specially?

Consider the following:

mount /dev/sda1 /var/lib/pgsql
mount /dev/sdb1 /srv1/pgsql/pg_xlog (which has a link
from /var/lib/pgsql/data/pg_xlog)

initdb -D /var/lib/pgsql/data -X /var/lib/pgsql/data/pg_xlog

Will fail; now you have multiple steps to get everything where it
should be.

> We don't do this
> for any other subdirectory of PGDATA. The extra logic would be a

Well the only other directory it would even matter for would be pg_clog
(maybe). I grant that it is a very little feature that could be lived
without.

> nuisance and for no great gain in functionality that I can see.
>

In an environment where you are provisioning many spindle machines over
many differently mounts and raid configurations it could be useful. The
question is; is it worth it? I don't know. I was just trying to
understand exactly what David was talking about and offer some
suggestions.

> This whole discussion springs from a misconception apparently, so
> let's just move on.

Well that pretty much describes life doesn't it? :)

Sincerely,

Joshua D. Drake

--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate