Re: Detecting corrupted pages earlier

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
Re: Detecting corrupted pages earlier
Дата
Msg-id
Pine.LNX.4.44.0304031941210.2215-100000@peter.localdomain
Ответ на
Список
Дерево обсуждения
Re: Detecting corrupted pages earlier Hiroshi Inoue <Inoue@tpf.co.jp>
Re: Detecting corrupted pages earlier Tom Lane <tgl@sss.pgh.pa.us>
Re: Detecting corrupted pages earlier Kris Jurka <books@ejurka.com>
Re: Detecting corrupted pages earlier Tom Lane <tgl@sss.pgh.pa.us>
Re: Detecting corrupted pages earlier Kevin Brown <kevin@sysexperts.com>
Re: Detecting corrupted pages earlier Tom Lane <tgl@sss.pgh.pa.us>
Re: Detecting corrupted pages earlier Bruce Momjian <pgman@candle.pha.pa.us>
Re: Detecting corrupted pages earlier Tom Lane <tgl@sss.pgh.pa.us>
Re: Detecting corrupted pages earlier Kevin Brown <kevin@sysexperts.com>
Re: Detecting corrupted pages earlier Andrew Sullivan <andrew@libertyrms.info>
Re: Detecting corrupted pages earlier Jason Earl <jason.earl@simplot.com>
Re: Detecting corrupted pages earlier Andrew Sullivan <andrew@libertyrms.info>
Re: Detecting corrupted pages earlier Tom Lane <tgl@sss.pgh.pa.us>
Re: Detecting corrupted pages earlier Bruce Momjian <pgman@candle.pha.pa.us>
Re: Detecting corrupted pages earlier Alvaro Herrera <alvherre@dcc.uchile.cl>
Re: Detecting corrupted pages earlier Tom Lane <tgl@sss.pgh.pa.us>
Re: Detecting corrupted pages earlier Kevin Brown <kevin@sysexperts.com>
Re: Detecting corrupted pages earlier Tom Lane <tgl@sss.pgh.pa.us>
Re: Detecting corrupted pages earlier Vincent van Leeuwen <pgsql.spam@vinz.nl>
Re: Detecting corrupted pages earlier Tom Lane <tgl@sss.pgh.pa.us>
Re: Detecting corrupted pages earlier Vincent van Leeuwen <pgsql.spam@vinz.nl>
Re: Detecting corrupted pages earlier Peter Eisentraut <peter_e@gmx.net>
Re: Detecting corrupted pages earlier Tom Lane <tgl@sss.pgh.pa.us>
Re: Detecting corrupted pages earlier Andrew Sullivan <andrew@libertyrms.info>
Re: Detecting corrupted pages earlier Kevin Brown <kevin@sysexperts.com>
Re: Detecting corrupted pages earlier Tom Lane <tgl@sss.pgh.pa.us>
Re: Detecting corrupted pages earlier Andrew Sullivan <andrew@libertyrms.info>
Re: Detecting corrupted pages earlier Tom Lane <tgl@sss.pgh.pa.us>
Re: Detecting corrupted pages earlier Kevin Brown <kevin@sysexperts.com>
Tom Lane writes:

> Andrew Sullivan expressed concern about this, too.  The thing could
> be made a little more failsafe if we made it impossible to set
> ZERO_DAMAGED_PAGES to true in postgresql.conf, or by any means other
> than an actual SET command --- whose impact would then be limited to
> the current session.  This is kind of an ugly wart on the GUC mechanism,
> but I think not difficult to do with an assign_hook (it just has to
> refuse non-interactive settings).

Fighting against people who randomly change settings without being
informed about what they do is pointless.  It's like trying to prevent
'rm -rf /*'.  And it's not like you can easily set anything in
postgresql.conf by accident.

-- 
Peter Eisentraut   peter_e@gmx.net


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Peter Eisentraut
Дата:
FAQ