Specifying WAL Location in Streaming Replication

Поиск
Список
Период
Сортировка
От Matt Dee
Тема Specifying WAL Location in Streaming Replication
Дата
Msg-id CACdswHOd2yh9r-z6n2e7ek_4iasDoi7Gn_6ZC5B8MKdMRrKUGg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Specifying WAL Location in Streaming Replication
Список pgsql-general
Hi,

I am trying to use the streaming replication protocol described in https://www.postgresql.org/docs/10/static/protocol-replication.html to read logical decoding events from a replication slot.

I'm doing this by starting replication with START_REPLICATION, and sending down the most recent position consumed in a standby status update.  When starting replication, I want to begin reading from the last position "committed" by the standby status update.

In the documentation for START_REPLICATION, a required argument is the WAL location to begin streaming at, and I'm not sure what to use here.  I have been using 0, and it seems to work fine.  Additionally, it seems that when --startpos is not provided to pg_recvlogical, it defaults to just sending a wal location of 0.

While this seems to work, I feel a bit uneasy about it since I can't find any documentation explaining why this works or what this argument does when using a replication slot.  Any clarification would be appreciated.

Thanks,
-Matt

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

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: Cloning schemas
Следующее
От: Demitri Muna
Дата:
Сообщение: ddl_command_end not firing DROP events