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(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco