PostgreSQL 9.3 synchronous replication

Поиск
Список
Период
Сортировка
От Sergey Arlashin
Тема PostgreSQL 9.3 synchronous replication
Дата
Msg-id B0A4903C-64EA-4DE1-8676-F1177928F6AB@gmail.com
обсуждение исходный текст
Ответы Re: PostgreSQL 9.3 synchronous replication
Re: PostgreSQL 9.3 synchronous replication
Список pgsql-admin
Hi!

Recently I've found out that synchronous replication just guarantees that the commit has reached the transaction log on
theslave. Therefore that doesn't mean the slave has replayed the transaction log and a query against the slave will
showthe transaction's results. 

So I'm wondering if there is a way to ensure that once a transaction is committed the data is available on the slave
andI can get it by executing a query against the slave? 

--
Best regards,
Sergey Arlashin

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

Предыдущее
От: Glyn Astill
Дата:
Сообщение: Re: cannot drop an extension
Следующее
От: "Perry, Hemy"
Дата:
Сообщение: Re: pg_upgrade vs. pg_dump