Re: Regarding(Read Replica in RDS)

On Thu, Mar 7, 2024 at 7:43 AM ROHIT SACHDEVA <sachdeva(dot)rohit648(at)gmail(dot)com>
wrote:

> Hi Team,
>
> I have a setup in which there is one main database and one sharded
> database.
> Seeing the requirement regarding MIS, we plan to have a read replica of
> this setup, so we launch two read replicas, one for the main database and
> another for the sharded database.
> Now that I want to change the hostname in Postgres fdw in a read replica,
>

But keep the Primary definition of shard_stg the same as it was?

> I am getting this error:.
> ALTER SERVER shard_stg OPTIONS (SET host 'hostanme', SET port '5432');
>
> ERROR: cannot execute ALTER SERVER in a read-only transaction
> SQL state: 25006
>
> Can anyone let me know how to change the read replica to write so that I
> can execute this query once?
>

Changing a Read Replica to writable mode means that it's not a Read Replica
anymore.