On Mon, 25 Aug 2008 09:04:01 -0700
David Fetter <david@fetter.org> wrote:
> > > When -X is set to "existing", it would check whether pg_xlog is a
> > > directory and the only thing in $PGDATA. One way to do that is to
> > > add a new return code to check_data_dir() and a new branch of the
> > > case statement after it's called.
> >
> > Why is this useful? It seems like just extra complication.
At no time should I ask I DBA to do this:
service postgresql stop
mv /var/lib/pgsql/data/pg_xlog /xlogs/pg_xlog
ln -sf /xlogs/pg_xlog /var/lib/pgsql/data/pg_xlog
service postgresql start
We either need to provide a way to initialize it at initdb, allow
xlogs to be in table space or add a GUC for the location.
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
