Re: logical decoding cannot be used while in recovery 9.5 - Mailing list pgsql-admin

From bala jayaram
Subject Re: logical decoding cannot be used while in recovery 9.5
Date
Msg-id CANcY5AxnjWubhdNjuuMs1FXCPmFSaN=RF86sfMN1g5d1d49_RQ@mail.gmail.com
Whole thread Raw
In response to logical decoding cannot be used while in recovery 9.5  (bala jayaram <balajayaram22@gmail.com>)
Responses Re: logical decoding cannot be used while in recovery 9.5  (Andres Freund <andres@anarazel.de>)
List pgsql-admin
Hi team,

It would be great if could response on this? we are in mid of migration from Postgres9.5 to RDS of AWS using DMS

Thanks in advance,

Regards
Bala

On Wed, Jul 18, 2018 at 10:31 AM, bala jayaram <balajayaram22@gmail.com> wrote:
Hi There,

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

Thanks for the response

Regards
Bala

pgsql-admin by date:

Previous
From: "Alfonso Moscato"
Date:
Subject: repeated out of shared memory error - not related to max_locks_per_transaction
Next
From: 066ce286@free.fr
Date:
Subject: Re: repeated out of shared memory error - not related tomax_locks_per_transaction