pg_upgrade in primary/standby architecture

Поиск
Список
Период
Сортировка
От Murthy Nunna
Тема pg_upgrade in primary/standby architecture
Дата
Msg-id BD7563973EF8894D905C80593EE9A4ED34B0CF@MAIL02.fnal.gov
обсуждение исходный текст
Ответы Re: pg_upgrade in primary/standby architecture  (Venkata Balaji Nagothi <vbnpgc@gmail.com>)
Список pgsql-admin

Hello PGAdmins,

 

I am wondering if there is a way we can leverage replication set up to minimize outage caused by pg_upgrade in case of major version upgrade. We use streaming replication.

 

Scenario:

1.      Primary and standby are running 9.1.6 and I want to upgrade both to 9.2.4 (or 9.2.6)

2.      Streaming replication is used

3.      I cannot use pg_dump due to the size of the database. I have to use pg_upgrade

 

Thanks,

Murthy

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

Предыдущее
От: Kasia Tuszynska
Дата:
Сообщение: Re: looking for doc
Следующее
От: Venkata Balaji Nagothi
Дата:
Сообщение: Re: pg_upgrade in primary/standby architecture