Best practice

Поиск
Список
Период
Сортировка
От geustace@godzone.net.nz
Тема Best practice
Дата
Msg-id 20010419222120.8A3441B46B@agree-6.godzone.net.nz
обсуждение исходный текст
Ответы Re: Best practice  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: locale & glibc 2.2.2
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: < Int4 - limit >