Re: same postmaster, different directory? V7.0.2 - Mailing list pgsql-admin

From John McKown
Subject Re: same postmaster, different directory? V7.0.2
Date
Msg-id Pine.LNX.4.21.0009111635220.32382-100000@linux2.johnmckown.net
Whole thread Raw
In response to same postmaster, different directory? V7.0.2  (Brian Horan <bhoran@herald.com>)
List pgsql-admin
On Mon, 11 Sep 2000, Brian Horan wrote:

> Howdy, I was wondering if anyone can help me, I'm running Postgres
> version 7.0.2,
> and I have several existing databases in /var and wanted to put one in
> /home, because of disk space.
>
> my only problem is that It will not let me do so, no matter what.
> Postgres was installed via rpm on RatHead 6.2
> and if there is something I can edit in a source file, that is not a
> problem.
>
> Any thoughts? coments?
>

I haven't tried this, myself. But the User's Guide has a section on
"Alternate Database Locations" and using the $PGDATA2 environment
variable. Have you tried this? I think, in this case, you will need to
change the PostgreSQL startup script to initialize the $PGDATA2
variable. On my RedHat system, this is, /etc/rc.d/init.d/postgresql
The directory specified must be owned (or at least rwx access) by the
PostgreSQL backend's userid.

John


pgsql-admin by date:

Previous
From: Brian Horan
Date:
Subject: same postmaster, different directory? V7.0.2
Next
From: Tim Quinlan
Date:
Subject: Re: backup/restore