Обсуждение: Separating the ro directory of the DB engine itself from the rw data areas . . .

~
 I need to configure postgreSQL in a way that I could run it from a
directory mounted as read only, with separate rw partitions mounted
for the data, logs, . . .
~
 What would be the steps to follow and the issues to take into consideration?
~
 thanks
 lbrtchx

 ... better yet; is it possible to configure postgreSQL in a way that
it depends on external variables set  via the OS in the same process
in which it is started?
~
 lbrtchx

On 2011-01-24, Albretch Mueller <lbrtchx@gmail.com> wrote:
> ~
>  I need to configure postgreSQL in a way that I could run it from a
> directory mounted as read only, with separate rw partitions mounted
> for the data, logs, . . .
> ~
>  What would be the steps to follow and the issues to take into consideration?

first read through the main config file

as far as I know postgres doesn't need to write the main cluster
directory (/var/lib/postgres/8.4/main here - a debian variant)
only the subdirectories off it data,xlog etc...

--
⚂⚃ 100% natural

On 2011-01-24, Albretch Mueller <lbrtchx@gmail.com> wrote:
>  ... better yet; is it possible to configure postgreSQL in a way that
> it depends on external variables set  via the OS in the same process
> in which it is started?

Debian manages that somehow. I've got two 8.4 clusters running and
only one copy of the binaries installed,  I think they use a
command-line option to specify the location of the config files.

--
⚂⚃ 100% natural

On Mon, Jan 24, 2011 at 10:12:28PM +0000, Albretch Mueller wrote:
>  ... better yet; is it possible to configure postgreSQL in a way that
> it depends on external variables set  via the OS in the same process
> in which it is started?

Sure.  Use the -D command-line switch or the $PGDATA environment variable.

A

--
Andrew Sullivan
ajs@crankycanuck.ca