On 2019-12-12 01:37, Mike Lissner wrote:
> I've got a server at example.com <http://example.com> that currently
> publishes logical replication to a server in AWS RDS. I plan to move the
> server at example.com <http://example.com> so that it has a new IP
> address (but same domain name).
>
> I'm curious if anybody knows how the logical replication subscriber in
> AWS would handle that.
>
> There's at least three layers where the DNS might be cached, creating
> breakage once the move is complete:
>
> - Postgres itself
>
> - AWS's postgresql fork in RDS might have something
>
> - The OS underlying amazon's RDS service
Postgres itself doesn't cache any host name resolution results. I don't
know about the other two pieces.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services