synchronous replication + fsync=off?

Поиск
Список
Период
Сортировка
От Schubert, Joerg
Тема synchronous replication + fsync=off?
Дата
Msg-id 694FA4BB1769914095CAD9E7FA4275E8EE4E81@cbmail.cebacus.lan
обсуждение исходный текст
Ответы Re: synchronous replication + fsync=off?  (Gregg Jaskiewicz <gryzman@gmail.com>)
Re: synchronous replication + fsync=off?  (Jaime Casanova <jaime@2ndquadrant.com>)
Список pgsql-general
Hello,

I have two servers with battery backed power supply (USV). So it is unlikely, that both will crash at the same time.

Will synchronous replication work with fsync=off?
That means we will commit to system cache, but not to disk. Data will not survive a system crash but the second system should still be consistent.

Or: will it work with
master: fsync=off
and
slave(s): fsync=on?
In this case master is free for read-queries and slave has time to do all the heavy writing. Data on master will not survive a crash but can be restored from slave.

Thanks,

Joerg


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

Предыдущее
От: Arctic Toucan
Дата:
Сообщение: Transaction wraparound problem due to wrong datfrozenxid?
Следующее
От: andreas@a-kretschmer.de
Дата:
Сообщение: Re: How to lock and unlock table in postgresql