Обсуждение: same postmaster, different directory? V7.0.2

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?

yes, I have RTFM'd


--
     ,~,
      v     Brian Horan
    /(|)\   Systems Analyst/Programmer
   /( | )\  Miami Herald Publishing Company
  //( | )\\ bhoran@herald.com     cell: (954) 296-7807
-----"-"-----------------------------------------

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

Which FM did you read?  There are several, but the Admin Guide talks about
disk management in chapter 10.

I put my databases in /home with postmaster running like this:
/usr/local/pgsql/bin/postmaster -D /home/post/data -i

--
Jeremy Buchmann
System Admin/Database Programmer
Wells Gaming Research

----------
>From: Brian Horan <bhoran@herald.com>
>To: pgsql-admin@postgresql.org
>Subject: [ADMIN] same postmaster, different directory? V7.0.2
>Date: Mon, Sep 11, 2000, 10:42 AM
>

> 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?
>
> yes, I have RTFM'd
>
>
> --
>      ,~,
>       v     Brian Horan
>     /(|)\   Systems Analyst/Programmer
>    /( | )\  Miami Herald Publishing Company
>   //( | )\\ bhoran@herald.com     cell: (954) 296-7807
> -----"-"-----------------------------------------
>
>
>
>