From: | John McKown <joarmc(at)swbell(dot)net> |
---|---|
To: | Brian Horan <bhoran(at)herald(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: same postmaster, different directory? V7.0.2 |
Date: | 2000-09-11 21:38:49 |
Message-ID: | Pine.LNX.4.21.0009111635220.32382-100000@linux2.johnmckown.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Quinlan | 2000-09-11 23:26:56 | Re: backup/restore |
Previous Message | Brian Horan | 2000-09-11 17:42:29 | same postmaster, different directory? V7.0.2 |