Обсуждение: upgrade postgres 9.5 to 9.6

Hi,

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.



Regards,
Atul

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 slony, although pglogical is more
powerful.

I hope that this can help you 

Regards,
Enrico

On Fri, 15 Jan 2021 18:47:51 +0530
Atul Kumar <akumar14871@gmail.com> wrote:

> Hi,
> 
> 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.
> 
> 
> 
> Regards,
> Atul

-- 
Enrico Pirozzi <sscotty71@gmail.com>

May you provide me steps to perform it (logical replication upgrade).

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_upgrade with the --link option should only take a few minutes.


Is there a reason you are upgrading to 9.6 and not 12 or 13?

9.6 will be end-of-live this November (in 10 months), you will have to do another upgrade then.

Thomas

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 default version in the distro they're migrating to, and Security Policy dictates that No Outside Software is allowed.  (Last year, I watched in horror as a database was upgraded from 8.4 to 9.2 for that very reason.)

9.6 will be end-of-live this November (in 10 months), you will have to do another upgrade then.

You'd be shocked to see how much data is pumped through old Postgresql databases.  "It works, so we're not going to fix it."  And they don't want to pony up for a new version of the application, and spend the money (manpower and h/w resources) validating it.