Re: Why database is corrupted after re-booting

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: Why database is corrupted after re-booting
Дата
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE92E7CF@algol.sollentuna.se
обсуждение исходный текст
Ответ на Why database is corrupted after re-booting  ("Andrus" <eetasoft@online.ee>)
Список pgsql-general
> 1. Windows XP
> 2. QUANTUM FIREBALLP LM20.5  (IDE drive)
> 3. Write caching is off in XP device manager
> 4. fsync is ON in Postgres 8

Coming late into the discussion, there is one more note I'd add to this
- if you're on windows and want to be extra secure, also set
wal_sync_method=fsync_writethrough. This will get it through most (I
would say all if I was sure, but I'm not) IDE disks that lie about write
completion.

//Magnus

В списке pgsql-general по дате отправления:

Предыдущее
От: John Sidney-Woollett
Дата:
Сообщение: Re: Please HELP - URGENT - transaction wraparound error
Следующее
От: David Eduardo Gómez Noguera
Дата:
Сообщение: Re: querying while copying into a table and optimizations