logical replication on 9.6: replica configuration

Поиск
Список
Период
Сортировка
От Paul Costello
Тема logical replication on 9.6: replica configuration
Дата
Msg-id CADX_XgY7biS2XJJc6bnUuyCKpPsmtziBPZZ=95F8YYEijGmAhA@mail.gmail.com
обсуждение исходный текст
Ответы Re: logical replication on 9.6: replica configuration  (Jeremy Schneider <schneider@ardentperf.com>)
Список pgsql-general
I need to create a read-only replica in AWS environment.  I can't use AWS/RDS built-in read replica functionaility due to security concerns, so I'm tied to using logical replication, on postgres 9.6.  How do I configure a replica db to receive the contents of the replication slot on master? 

I was able to get logical replication going with the following 2 commands:

SELECT pg_create_logical_replication_slot('test_slot', 'test_decoding');
pg_recvlogical -d test --slot test_slot --start -f - &

I'm very unclear on where to go from there to stand up a read-replica db.

Thanks,
Paul C.

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Linked data from upgrade after VACUUM FULL not deleted.
Следующее
От: Jeremy Schneider
Дата:
Сообщение: Re: logical replication on 9.6: replica configuration