Best practice - Mailing list pgsql-general

From geustace@godzone.net.nz
Subject Best practice
Date
Msg-id 20010419222120.8A3441B46B@agree-6.godzone.net.nz
Whole thread Raw
Responses Re: Best practice
List pgsql-general
Now that 7.1 has arrived, I would appreciate some feed back on the
following comments.

We use Ingres where I work and when setting up a server we always
try to ensure that the log and data files are on different spindles.

From both experience and advice from CAI, one can always recover a
database after a hardware failure or system crash, if any two of the
following are in good condition

Backup, Logfile, Datafiles.

I know that PostgreSQL isn't Ingres but there must be some useful
experiences from both experts and users alike. Is there any recommended
'placement' for the respective postgresql files.

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen and Rosanne Eustace,
GodZone Internet Services, a division of AGRE Enterprises Ltd.,
P.O. Box 8020, Palmerston North, New Zealand 5301
Ph/Fax: +64 6 357 8168, Mob: +64 21 424 015



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: locale & glibc 2.2.2
Next
From: Peter Eisentraut
Date:
Subject: Re: < Int4 - limit >