Re: Regarding(Read Replica in RDS)
| От | Ron Johnson |
|---|---|
| Тема | Re: Regarding(Read Replica in RDS) |
| Дата | |
| Msg-id | CANzqJaCq4DKOs8T0DzH_OWPghem7gGpU2SGXqmf37_LSJfQTOg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Regarding(Read Replica in RDS) (ROHIT SACHDEVA <sachdeva.rohit648@gmail.com>) |
| Ответы |
Re: Regarding(Read Replica in RDS)
|
| Список | pgsql-admin |
On Thu, Mar 7, 2024 at 7:43 AM ROHIT SACHDEVA <sachdeva.rohit648@gmail.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: 25006Can 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.
В списке pgsql-admin по дате отправления: