Re: Regarding(Read Replica in RDS)

[Ron Johnson <ronljohnsonjr@xxxxxxxxx>]

On Thu, Mar 7, 2024 at 11:25 AM ROHIT SACHDEVA <sachdeva.rohit648@xxxxxxxxx> 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@xxxxxxxxx> wrote:

On Thu, Mar 7, 2024 at 9:26 AM Dan Smith <j.daniel.smith1@xxxxxxxxx> 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".