| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | "Sheena, Prabhjot" <Prabhjot(dot)Singh(at)classmates(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 9.4 upgrade Help using pg_upgrade |
| Date: | 2015-12-03 00:58:13 |
| Message-ID: | 20151203005813.GA27517@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Dec 3, 2015 at 12:33:25AM +0000, Sheena, Prabhjot wrote:
> Current Architecture
>
> Primary Hot Standby
>
> Postgresql 9.3 Postgresql 9.3
> DB Size 1.4 TB Database Size 1.4 TB
>
>
> Want to upgrade both primary and hot Standby to 9.4 at same time. I m not able
> to figure out how to upgrade Hot standby and primary simultaneously. What ever
> I have read so far only tells me about upgrading primary which I am able to do
> it . Can anyone please guide me How to upgrade Secondary database so that I
> don’t have to build standby again from the scratch after upgrading primary
> database?
Yes, read the 9.5 docs for upgrading the standby --- it also works for
9.4 and earlier:
http://momjian.us/main/blogs/pgblog/2015.html#June_10_2015
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2015-12-03 01:06:34 | json indexing and data types |
| Previous Message | Jim Nasby | 2015-12-03 00:39:04 | Re: 2 questions |