RE: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools?

Поиск
Список
Период
Сортировка
От HECTOR INGERTO
Тема RE: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools?
Дата
Msg-id GV1P189MB20363DCA2B387BB3E4B2643FF5C69@GV1P189MB2036.EURP189.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools?  (Bruce Momjian <bruce@momjian.us>)
Re: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general

> Another case: a transaction COMMITs, and a slightly later transaction reads the data
> and sets a hint bit.  If the snapshot of the file system with the data directory in it
> is slightly later than the snapshot of the file system with "pg_wal", the COMMIT might
> not be part of the snapshot, but the hint bit could be.
>
> Then these uncommitted data could be visible if you recover from the snapshot.
>
> Yours,
> Laurenz Albe

 

Thank you all. I have it clearer now.

 

As a last point. Making the snapshot to the WAL dataset first or last would make any difference?

 

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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Tablespace OID, database OID, relfilenode
Следующее
От: Wiwwo Staff
Дата:
Сообщение: Re: Tablespace OID, database OID, relfilenode