Re: location for pgdata

On 9 Jan 2002 at 10:11, Josh Berkus wrote:
<snip>
> 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/.

hi Josh,

thanks for reacting.

since the (test) server will be mainly a database server, i made my
/var the biggest partition and put the pg data in there. but, is there
any convention or default on where pg data are placed? i ask this to
make sure i don't run into trouble with an upgrade / RPM / DEB by
making an exotic choice now.

--
Jules Alberts.