Re: pg_upgrade in primary/standby architecture
| От | Venkata Balaji Nagothi |
|---|---|
| Тема | Re: pg_upgrade in primary/standby architecture |
| Дата | |
| Msg-id | CAHBAh5thJrGVi16X46yTdrt2cF6V4ZuJ8MvUonhbzcOo_eDvzg@mail.gmail.com обсуждение исходный текст |
| Ответ на | pg_upgrade in primary/standby architecture (Murthy Nunna <mnunna@fnal.gov>) |
| Ответы |
Re: pg_upgrade in primary/standby architecture
|
| Список | pgsql-admin |
On Tue, Mar 18, 2014 at 1:52 PM, Murthy Nunna <mnunna@fnal.gov> wrote:
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.
If i got you correct - Streaming Replication cannot be setup between two different versions of PostgreSQL.
Scenario:
1. Primary and standby are running 9.1.6 and I want to upgrade both to 9.2.4 (or 9.2.6)
Though its not an straight forward or easy way to upgrade a big database - Did you think of Slony as an option ?
We have used Slony in the past to upgrade databases to reduce lengthy downtime. This depends on lot of factors though.
Regards.
Venkata Balaji N
Sr. Database Administrator
Fujitsu Australia
В списке pgsql-admin по дате отправления: