Re: Pglogical 2.3.0 in AWS RDS 12.2

On 6/1/20 09:39, Igor Polishchuk wrote:
> Hello everybody, 
> Has anybody succeeded with using pglogical in AWS Postgresql 12.2? 
> They have pglogical v2.3.0, and it has this
> issue https://github.com/2ndQuadrant/pglogical/issues/240, which was
> fixed in the 2.3.1. 
> However, one cannot upgrade pglogical to 2.3.1 in RDS. Just curious if
> somebody found a work around. Otherwise, it seems unusable with RDS
> v12.2 right now. 

When I can, I usually encourage people to report RDS specific issues on
the AWS forums; the postgresql.org mailing lists are most suited for
questions that are not RDS-specific but apply to PostgreSQL in general.

https://forums.aws.amazon.com/forum.jspa?forumID=60

That said - AWS is aware of this issue. Extension updates on RDS are
coupled with minor releases (typically coming every three months from
postgresql.org) so just keep checking the future new minor releases on
RDS until you see something. And if you don't have a support agreement
with AWS then make noise on the forums, product managers do read them. :)

The pgLogical extension is published and maintained by 2ndQuadrant. It
seems to me that a good place to discuss whether any temporary
workaround exists might be right on the github issue itself even though
it's closed. (Does 2ndQuadrant have any email lists or forums?) I
haven't looked at this issue so I don't know if there's any workaround
that could be used with 2.3.0 on RDS. I also don't know much about
2ndQuadrant's support agreements/offerings, and whether there's
something there that could give general advice about the open source
pgLogical extension.

Hope this helps,
Jeremy

--
Jeremy Schneider
Database Engineer
Amazon Web Services