Re: logical Replication

Поиск
Список
Период
Сортировка
От Maletin von Oertzen
Тема Re: logical Replication
Дата
Msg-id 941ED3D2-51B4-42FC-8118-50124F9E8F80@gmail.com
обсуждение исходный текст
Ответ на Re: logical Replication  (pavan95 <pavan.postgresdba@gmail.com>)
Список pgsql-admin
At 2018-08-20 09:59 pavan95 wrote:

Actually there are no running transactions in the database. When I insert
the data suppose 100 records in a table and after commit connect to the
subscriber database and issue row count from that particular table, I am
finding that the data didn't got replicated.

Later which I will proceed with :
ALTER SUBSCRIPTION my_sub_name WITH REFRESH PUBLICATION WITH( COPY_DATA)

Even then I can't see the data replicated in the subscriber side.

Then I will go with dropping and recreating the SUBSCRIPTION on the
subscriber side where I will see that inserted 100 records in the subscriber
side.

Again will try inserting another 1000 records which will get replicated
within microsecond(I guess).

Is it possible, that there is a "alter table replica identity"-statement missing?

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

Предыдущее
От: David Steele
Дата:
Сообщение: Re: pgbackrest: backup from standby
Следующее
От: soumitra bhandary
Дата:
Сообщение: Not able to increase TPS in Postgres BDR set up using pgbench utility