Re: [COMMITTERS] pgsql-server/src

From: Greg Copeland <greg(at)CopelandConsulting(dot)Net>
To: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Thomas Lockhart <lockhart(at)fourpalms(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [COMMITTERS] pgsql-server/src
Date: 2002-08-13 05:30:35
Message-ID: 1029216635.4796.267.camel@mouse.copelandconsulting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On Tue, 2002-08-13 at 00:16, Marc G. Fournier wrote:
>
> Myself, if I'm going to move something around, it will be after the server
> has been running for a while and I've added in more drive space in order
> to correct a problem i didn't anticipate (namely, disk I/O) ... at that
> point, I really don't wan tto have to dump/re-initdb/load just to move the
> xlog directory to that new drive ...
>

Okay, fair enough. But do we really need to have environment variables
for this? Sounds like we need a stand alone utility which does the
associated magic in the database which moves the xlog and associated
internal pointers. Doing so would assuming that all "be"s for the
database have been shutdown or simply would not go into effect until
restarted. Is this feasible?

For something that would seemingly be infrequently used, creating
environment variables would seemingly be rather error prone.

Requiring soft links also doesn't strike me as a good portable idea
either...not to mention I've been bitten by them before too.

Sign,
Greg Copeland

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Thomas Lockhart 2002-08-13 06:09:14 Re: [COMMITTERS] pgsql-server/src backend/tcop/postgres.cbacke
Previous Message Bruce Momjian 2002-08-13 05:26:55 Re: [COMMITTERS] pgsql-server/src

Browse pgsql-hackers by date

  From Date Subject
Next Message Curt Sampson 2002-08-13 05:33:46 Re: OOP real life example (was Re: Why is MySQL more
Previous Message Bruce Momjian 2002-08-13 05:26:55 Re: [COMMITTERS] pgsql-server/src