On 1/15/21 9:17 AM, Thomas Kellerer wrote:
[snip]
Is there a reason you are upgrading to 9.6 and not 12 or 13?
The application software vendor might only certify the application on 9.6.
Or /management/, in their infinite "wisdom", might insist on a One-version
upgrade.
Or 9.6 might be the defa
Atul Kumar schrieb am 15.01.2021 um 14:17:
> I want to upgrade my server from postgres 9.5 to 9.6, but my DB size
> is in TBs and I want to do it in minimum downtime (2-3 hours) so
> please help me how should I perform it.
>
>
> Please share the document, if possible, it will be grateful.
pg_upgra
May you provide me steps to perform it (logical replication upgrade).
I will be thankful to you.
Regards
Atul
On Friday, January 15, 2021, Enrico Pirozzi wrote:
> Hi Atul,
> you could use logical replication and do an hot upgrade between the 2
> servers with a zero downtime ;)
>
> If you wa
Hi Atul,
you could use logical replication and do an hot upgrade between the 2 servers
with a zero downtime ;)
If you want to use logical replication between a 9.5 , 9.6 version you could
use for example pglogical.
You could achieve the same result using an external logic replication tool like
