Re: logical decoding cannot be used while in recovery 9.5

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: logical decoding cannot be used while in recovery 9.5
Дата
Msg-id 20180720151217.wxqpbytoiizdm6ml@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: logical decoding cannot be used while in recovery 9.5  (bala jayaram <balajayaram22@gmail.com>)
Список pgsql-admin
Hi,

Please don't top-quote.

On 2018-07-20 07:18:28 -0400, bala jayaram wrote:
> It would be great if could response on this? we are in mid of migration
> from Postgres9.5 to RDS of AWS using DMS

This isn't free RDS / DMS support. In fact, we can only make informed
inferences on how they actually work, given they're closed source tools.


> > we are getting this error "logical decoding cannot be used while in
> > recovery" when using AWS DMS in one of the slave which is in logical as
> > wal_level. AWS DMS job is not running due to the above error. After seeing
> > the forums, we cannot use standby slave for logical decoding. Is this issue
> > fixed? currently we are in 9.5

No, logical decoding cannot be used on a standby. There's ongoing work
in changing that, but it's not yet supported.

Greetings,

Andres Freund


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: R: repeated out of shared memory error - not related to max_locks_per_transaction
Следующее
От: Andres Freund
Дата:
Сообщение: Re: repeated out of shared memory error - not related tomax_locks_per_transaction