Logical replication DNS cache

From: Mike Lissner <mlissner(at)michaeljaylissner(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Logical replication DNS cache
Date: 2019-12-12 00:37:49
Message-ID: CAMp9=Ey8wrD-1CzPim+jLJqb40sFKuygs_LzwhYQCam1w_c_5w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've got a server at example.com that currently publishes logical
replication to a server in AWS RDS. I plan to move the server at 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

I expect this is a tough question unless somebody has done this before, but
any ideas on how postgresql would handle this kind of thing? Or is there a
way to flush the DNS cache that postgresql (or RDS or the OS) has?

I'm just beginning to explore this, but if anybody has experience, I'd love
to hear it.

Thanks,

Mike

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Gierth 2019-12-12 05:03:59 Re: Encoding/collation question
Previous Message Dan shmidt 2019-12-11 21:17:19 Re: Logical Replication of Multiple Schema Versions