Home > mailing lists

Re: Regarding(Read Replica in RDS) - Mailing list pgsql-admin

From	Ron Johnson
Subject	Re: Regarding(Read Replica in RDS)
Date	March 7 20:21:07
Msg-id	CANzqJaC033MpHbZphPnkACd1X9NbCwCzOAXXoB8GxFGcxE6-LA@mail.gmail.com Whole thread Raw
In response to	Re: Regarding(Read Replica in RDS) (ROHIT SACHDEVA <sachdeva.rohit648@gmail.com>)
List	pgsql-admin

Tree view

On Thu, Mar 7, 2024 at 11:25 AM ROHIT SACHDEVA <sachdeva.rohit648@gmail.com> wrote:

Any other option.

Create a second fdw server (on the primary?), with the new host name. That SERVER definition should be replicated to the Secondary, where you can then use it.

Bcz if I promote can I rollback again.

When you roll back... the altered server definition will also be rolled back.

Regards
Rohit Sachdeva
On Thu, 7 Mar, 2024, 8:00 pm Ron Johnson, <ronljohnsonjr@gmail.com> wrote:
On Thu, Mar 7, 2024 at 9:26 AM Dan Smith <j.daniel.smith1@gmail.com> wrote:
You can promote a Read Replica via AWS CLI or AWS Web Console.

Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html#USER_ReadRepl.Promote
https://awscli.amazonaws.com/v2/documentation/api/latest/reference/rds/promote-read-replica.html
aws rds promote-read-replica \    --db-instance-identifier test-instance-repl
Which breaks replication. You can't "demote".

pgsql-admin by date:

From: Keith
Date: 07 March, 19:46:51
Subject: Re: Regarding(Read Replica in RDS)

From: Brett Bisesti
Date: 07 March, 23:14:32
Subject: Advanced DBA Training

Re: Regarding(Read Replica in RDS) - Mailing list pgsql-admin

Previous

Next