Re: Regarding(Read Replica in RDS)

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Regarding(Read Replica in RDS)
Дата
Msg-id CANzqJaC033MpHbZphPnkACd1X9NbCwCzOAXXoB8GxFGcxE6-LA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Regarding(Read Replica in RDS)  (ROHIT SACHDEVA <sachdeva.rohit648@gmail.com>)
Список pgsql-admin
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: 
aws rds promote-read-replica \    --db-instance-identifier test-instance-repl
 Which breaks replication.  You can't "demote".

В списке pgsql-admin по дате отправления:

Предыдущее
От: Keith
Дата:
Сообщение: Re: Regarding(Read Replica in RDS)
Следующее
От: Brett Bisesti
Дата:
Сообщение: Advanced DBA Training