From: | "Jules Alberts" <julesa(at)arbodienst-limburg(dot)nl> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: location for pgdata |
Date: | 2002-01-10 07:49:15 |
Message-ID: | 200201100755.g0A7tvLs011944@artemis.cuci.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Earl | 2002-01-10 15:02:44 | Re: location for pgdata |
Previous Message | Josh Berkus | 2002-01-09 18:11:04 | Re: location for pgdata |