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, 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?
Have a Good day !!!
Regards
Rohit Sachdeva
Regards
Rohit Sachdeva
