I've been asked to assist a DBA with setting up a postgres system.
I cannot seem to find any documentation on how to set up the filesystem
in an ideal fashion, other than the usual installation in /usr/local/pgsql.
This is likely a FAQ, so point me to it if it is, but otherwise, how would you
set up a box for a largish database (around 2Gb)? I have 4x18Gb drives to
play with, most likely as a single Raid5 50Gb volume.
Would you have a partition just for transaction logs? How would you slice
up the box as a dedicated pgsql server? The o/s is redhat.
pgsql-novice by date
|Next:||From: Ludwig Lim||Date: 2002-05-30 04:41:15|
|Subject: PL/PgSQL Cursors vs. Pl/SQL Cursors|
|Previous:||From: Ron Johnson||Date: 2002-05-29 23:29:54|
|Subject: [Fwd: Re: CPU types and queries...]|