postgres on a non-journaling filesystem

Поиск
Список
Период
Сортировка
От maayan mordehai
Тема postgres on a non-journaling filesystem
Дата
Msg-id CAO56m1ABHqQyOA-157VKUv9NaXH_jc-EHyF=xKRYA_Q0Z5QM2g@mail.gmail.com
обсуждение исходный текст
Ответы Re: postgres on a non-journaling filesystem  (Heikki Linnakangas <hlinnaka@iki.fi>)
Список pgsql-hackers
hello,

I'm Maayan, I'm in a DBA team that uses postgresql.
I saw in the documentation on wals:
In the tip box that, it's better not to use a  journaling filesystem. and I wanted to ask how it works?
can't we get corruption that we can't recover from?
I mean what if postgres in the middle of a write to a wal and there is a crash, and it didn't finish. 
I'm assuming it will detect it when we will start postgres and write that it was rolled back, am I right?
and how does it work in the data level? if some of the 8k block is written but not all of it, and then there is a crash, how postgres deals with it?

Thanks in advance 

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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: Rare SSL failures on eelpout
Следующее
От: "Bossart, Nathan"
Дата:
Сообщение: Re: A few new options for vacuumdb