Re: Logical replication DNS cache

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