public inbox for [email protected]
help / color / mirror / Atom feedFrom: Shawn McKee <[email protected]>
To: vrms <[email protected]>
Cc: [email protected]
Subject: Re: Postgres compatibility with RHEL
Date: Sun, 8 Dec 2024 08:32:48 -0500
Message-ID: <CAHO_io1MXnHMd1GBwngZsu=f5bOhAm0FyOSrOXqK_W-NoTs5Ew@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CALOSYAfZvYFYpqNgiLG=GbZK5UNakcvqE6Pm7x9mRGqsEnQ6hQ@mail.gmail.com>
<[email protected]>
Hi Siddhartha,
We just did something similar. We had Postrgresql 11 on CentOS 7.9 and
needed to get to RHEL 9.4
We set up new hardware as RHEL 9.4 and installed Postgresql 15.10 on it but
didn't initialize the DB.
-
dnf install --enablerepo=pgdg15 postgresql15.x86_64
postgresql15-contrib.x86_64 postgresql15-libs.x86_64
postgresql15-server.x86_64
-
(version 15.10-1PGDG)
You can get the repos set up on CentOS 7 via:
yum --disablerepo=* -y install
https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rp...
We then upgraded the CentOS 7.9 system using the --link option:
/usr/pgsql-15/bin/pg_upgrade --link --verbose &> ~/pg_upgrade_15.log
On our DB, this took only about 9 seconds (we run just a couple DBs but one
has is tracking 30 million file details) but we have the DB on NVMe devices.
Once you have the master CentOS 7.9 version on Postgresql 15, you can set
up the RHEL 9.4 version as a slave standby node using pg_basebackup. You
can google for guides like
https://medium.com/@wasiualhasib/postgresql-15-master-slave-configuration-using-streaming-replicatio...
Once you are synchronized, you can shutdown the master, shutdown the slave,
reconfigure the slave to be the former master (change hostname and IP
adddress(es)) and bring it back up.
To get to 16 you can run the pg_upgrade command similarly to how you did
the original master on CentOS 7.9. This process should minimize the
amount of time you have to be down.
Shawn
On Sat, Dec 7, 2024 at 11:43 AM vrms <[email protected]> wrote:
> I believe the best way would be to
>
> 1. setup a new rhel9 server with pg16
> 2. get a dump (pg_dumpall) from the old machine onto the new machine
> 3. restore that dump
> 4. copy pg_hba.conf and postgresql.conf over to the new machine
> 4.1. make sure to keep the new postgresql.conf and adjust custom
> settings you may have on the old machine with making sure those settings
> have not changed
>
> If you want to do this close to zero downtime, you could set up logical
> replication to the new pg16 machine and once that is finished switch over
> and promote that to be the new main.
>
>
>
> On 04.12.24 14:03, Siddhartha Jain wrote:
>
> Hi,
>
> Please let me know if Postgresql 16 is compatible with RHEL 7.9 version
> and RHEL 9.1 version.
> I need to upgrade postgres from 11.22 to 16.6 and need information for
> that as the OS version is going to upgrade from 7.9 to 9.1.
> Also, let me know the strategies if any to upgrade both RHEL and DB.
>
> Thanks,
> Siddhartha
>
>
view thread (7+ 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: Postgres compatibility with RHEL
In-Reply-To: <CAHO_io1MXnHMd1GBwngZsu=f5bOhAm0FyOSrOXqK_W-NoTs5Ew@mail.gmail.com>
* 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