Re: location for pgdata

Jules,

> i'm setting up a pg 7.1.3 test system on a redhat 7.2 box and i'm
> wondering what the best location would be to put the data. the manual
> gives /usr/local/pgsql/data as an example, but i thought somewhere in
> /var would be a better idea, because the size of the db will
> obviously
> vary. would /var/pgsql/data be a good idea?

4 rules:
1. The pgsql/data directory, as all pgsql/ directories, must belong to
the postgres user.
2. The database will grow, and the log file sizes will fluctuate
constantly.  So you want plenty of extra partition space.
3. Nothing other than Postgres data and files should be in the data
directory to avoid overwriting important files.
4. You and anybody else who uses the system should be able to identify
the Postgres directory easily.

I fulfill the above by putting the data in /usr/local/pgsql/data, but
then putting that directory on its own partition.  You could do it by
putting it in /var/pgsql/data/.

-Josh


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco