public inbox for [email protected]  

help / color / mirror / Atom feed

From: hubert depesz lubaczewski <[email protected]>
To: Carrillo, Juan R <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: New to postgres
Date: Wed, 2 Jun 2021 09:07:59 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CO6PR09MB795940E3684F83A1DE8B24A1D23E9@CO6PR09MB7959.namprd09.prod.outlook.com>
References: <CO6PR09MB795940E3684F83A1DE8B24A1D23E9@CO6PR09MB7959.namprd09.prod.outlook.com>

On Tue, Jun 01, 2021 at 07:14:13PM +0000, Carrillo, Juan R wrote:
> Good afternoon
> 
> I am New to postgres Database.  I have been tasked by my current
> management to upgrade our current postgres DB version 9.6.15 to
> a supported version of postgres.  I am not sure if we should upgrade
> to 10, 11, 12 or 13.  We are currently running postgres 9.6.15 on Red
> Hat Enterprise Linux Work Stations - Linux Version 7.  I believe we
> should be running Linux 8 on RHEL.  I was wondering if Dell Serers
> would support an upgrade of postgres 10 to Linux 8.  Again I am New to
> postgres DB and any assistance is appreciated.

Hi.
This is somewhat complicated.

First of all - you should try to upgrade to newest - 13.3.
Second - for RedHat-ish distributions there is
https://yum.postgresql.org/, and it seems that there is pg 13 for RH7
(https://yum.postgresql.org/packages/#pg13).

Now, about how to do the upgrade - there are many paths, some are
simple, some are more complicated, some require more downtime, some
less.

Which path you will chose depends on your data size, downtime
requirements, and expertise level.

Unfortunately I can't provide much more information about redhat, as
I simply don't know it, and am not sure what tools, especially for
upgrading, they provide.

Generally, I would suggest that you made a copy of your production
database on some side system (even your laptop/workstation), and try
various approaches.

Couple of tools, in order of easy to hard to learn from scratch:
1. pg_dump and pg_restore
2. pg_upgrade
3. pglogical replication

Best regards,

depesz

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: New to postgres
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox