From: | Ibrahim Edib Kokdemir <kokdemir(at)gmail(dot)com> |
---|---|
To: | Vikas Sharma <shavikas(at)gmail(dot)com> |
Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Postgresql & PGPool packages minor version different on Standby server |
Date: | 2018-07-18 15:12:48 |
Message-ID: | CABnTomKTfEkSzuGuKKShY1yOrwWoLXR5m-dmzXaKu=uG58nQAw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Vikas,
For the postgres service, we have the same case (each cluster members has
different minor version of 9.6) and there is no problem with that.
But be careful about extensions. Because sometimes an extension can require
an upgrade in its db structure otherwise it won't work. So if there is a
case like what I describe, you must upgrade the extension before put the
server in production.
I don't know about pgpool.
Regards,
İbrahim.
On Wed, 18 Jul 2018, 17:42 Vikas Sharma, <shavikas(at)gmail(dot)com> wrote:
> Hi All,
>
> We have Postgresql 9.5 Cluster with streaming replication and pgpool. The
> version of Postgres is 9.5.5 and Pgpool-II version 3.2.15.
>
> There is now hardware issue with the Standby Machine and it won't startup
> so we are building new Standby machine.
>
> My question is about the minor version of postgresql 9.5 available now. On
> postgresql repository site, I can't see postgres 9.5.5 and Pgpool-II-3.2.15
> instead there are 9.5.13 and PGpool-II-3.5.15
>
> Is it safe and fine to have postgres 9.5.5 and pgpool-II-3.2.15 on Master
> & postgres 9.5.13 and Pgpool-II-3.5.15 on Standby ?
> Please let me know.
>
> I know the postgres don't keep minor version in PG_VERSION file in data
> directory so should It be ok to use different minor versions on master &
> standby?
>
> Thanks in advance.
>
> Regards
> Vikas
>
From | Date | Subject | |
---|---|---|---|
Next Message | Márcio Antônio Sepp | 2018-07-18 16:16:43 | RES: Can't compile postgresql 11 on FreeBSD 11.1 |
Previous Message | Vikas Sharma | 2018-07-18 14:41:31 | Postgresql & PGPool packages minor version different on Standby server |