Adrian
Proposed new Server is intended to have higher OS Version (centos ver 9.0) and higher Postgres Version 15.10
Does logical replication will have issues , if the existing asis server is having Postgres ver 13.16.2 with Cent Os 7.0
with the new server having higher OS version Centos Ver 9.0 and then propose to have the Postgres to be upgraded
from ver 13.16.2 to 15.10
Hope u have understood my question
On Monday, December 2, 2024 at 06:47:10 PM EST, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
On 12/2/24 15:41, Bharani SV-forum wrote:
> Ron/Adrian
> Thanks for your input.
> Your suggestion is
>
> *option#1*
> ASIS-existing server = EC2 with Community PostgreSQL Ver 13.16.2*
> - ensure to capture all the pre.req meant for ver 15.10 are being met.
> - enable logical replication tagged to proposed new EC2 server
No, logical replication != pg_upgrade process.
> (with newer Higher OS Version ).
>
>
> Proposed-new EC2 server (with new Operating System version along
> Postgres Ver 13.16.2 and 15.10 Binaries)*
> - install postgres 13.16.2 binaries
> - have postgres setup on par with existing setup and having proper
> logical replication
Again, no.
> - install postgres 15.10 binaries
> - ensure to DISABLE auto startup and shutdown of postgres 13.16.2
> - ensure to DISABLE auto startup and shutdown of postgres 15.10
> - start postgres db ver 13.16.2 and ensure all are good. no errors
> in postgres log file
> - start performing pg_upgrade step to upgrade postgres from ver
> 13.16.2 to 15.10
>
> pl Vet the newer steps (revised version).
I don't know how much clearer it can be, follow the step by step
instructions shown here:
https://www.postgresql.org/docs/current/pgupgrade.html
"These are the steps to perform an upgrade with pg_upgrade:
[...]
"
>
>
> Regards
> Bharani
>
> On Monday, December 2, 2024 at 05:48:19 PM EST, Adrian Klaver
> <adrian.klaver@xxxxxxxxxxx> wrote:
>
>
> On 12/2/24 14:46, Adrian Klaver wrote:
> > On 12/2/24 14:31, Ron Johnson wrote:
> >> On Mon, Dec 2, 2024 at 5:18 PM Bharani SV-forum
> >> <esteembsv-forum@xxxxxxxxx <mailto:esteembsv-forum@xxxxxxxxx>
> <mailto:esteembsv-forum@xxxxxxxxx>> wrote:
> >>
> >> Team
> >> Pl Help in vetting my steps for Postgres DB upgrade from Ver 13.X to
> >> ver 15.X
> >>
> >> Env = EC2 based Community PostgreSQL Ver 13.16.2
> >>
> >> we will be performing upgrade of our EC2 server too along with new
> >> OS.
> >>
> >> Need help in vetting my steps for Postgres DB upgrade from Ver 13.X
> >> to ver 15.X
> >> *ASIS-existing server = EC2 with Community PostgreSQL Ver 13.16.2*
> >> - ensure to capture all the pre.req meant for ver 15.10 are being
> >> met.
> >> - shutdown db.
> >> - take offline full backup (PG_DATA folder alone) using OS command
> >>
> >> *Proposed-new EC2 server (with new Operating System version along
> >> Postgres Ver 15.10 Binaries)*
> >> - install postgres 15.10 binaries
> >> - ensure to DISABLE auto startup and shutdown of postgres 15.10
> >> - Restore offline full backup (PG_DATA folder alone) using OS
> >> command
> >> - start performing pg_upgrade step to upgrade postgres from ver
> >> 13.16.2 to 15.10
> >>
> >> please guide me, if i have missed any steps in the abovesaid process
> >>
> >> To start new DB features, planning to rollout out the following
> >> feature's alone
> >> a) TLE extension for password compliance
> >> b) parallelize vacuum jobs to utilize -j option
> >>
> >>
> >> To migrate from one server to another while upgrading, one must use
> >> pg_dump/pg_restore OR Logical Replication.
> >
> > Really?
> >
> > Then this:
> >
> > https://www.postgresql.org/docs/current/pgupgrade.html
> <https://www.postgresql.org/docs/current/pgupgrade.html>
> >
> > must be random nose.
>
> Oh yeah, that was smooth.
>
> Second attempt:
>
> ... must be random noise.
>
>
> >
> >>
> >> --
> >> Death to <Redacted>, and butter sauce.
> >> Don't boil me, I'm still alive.
> >> <Redacted> lobster!
> >
>
> --
> Adrian Klaver
> adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
> Ron/Adrian
> Thanks for your input.
> Your suggestion is
>
> *option#1*
> ASIS-existing server = EC2 with Community PostgreSQL Ver 13.16.2*
> - ensure to capture all the pre.req meant for ver 15.10 are being met.
> - enable logical replication tagged to proposed new EC2 server
No, logical replication != pg_upgrade process.
> (with newer Higher OS Version ).
>
>
> Proposed-new EC2 server (with new Operating System version along
> Postgres Ver 13.16.2 and 15.10 Binaries)*
> - install postgres 13.16.2 binaries
> - have postgres setup on par with existing setup and having proper
> logical replication
Again, no.
> - install postgres 15.10 binaries
> - ensure to DISABLE auto startup and shutdown of postgres 13.16.2
> - ensure to DISABLE auto startup and shutdown of postgres 15.10
> - start postgres db ver 13.16.2 and ensure all are good. no errors
> in postgres log file
> - start performing pg_upgrade step to upgrade postgres from ver
> 13.16.2 to 15.10
>
> pl Vet the newer steps (revised version).
I don't know how much clearer it can be, follow the step by step
instructions shown here:
https://www.postgresql.org/docs/current/pgupgrade.html
"These are the steps to perform an upgrade with pg_upgrade:
[...]
"
>
>
> Regards
> Bharani
>
> On Monday, December 2, 2024 at 05:48:19 PM EST, Adrian Klaver
> <adrian.klaver@xxxxxxxxxxx> wrote:
>
>
> On 12/2/24 14:46, Adrian Klaver wrote:
> > On 12/2/24 14:31, Ron Johnson wrote:
> >> On Mon, Dec 2, 2024 at 5:18 PM Bharani SV-forum
> >> <esteembsv-forum@xxxxxxxxx <mailto:esteembsv-forum@xxxxxxxxx>
> <mailto:esteembsv-forum@xxxxxxxxx>> wrote:
> >>
> >> Team
> >> Pl Help in vetting my steps for Postgres DB upgrade from Ver 13.X to
> >> ver 15.X
> >>
> >> Env = EC2 based Community PostgreSQL Ver 13.16.2
> >>
> >> we will be performing upgrade of our EC2 server too along with new
> >> OS.
> >>
> >> Need help in vetting my steps for Postgres DB upgrade from Ver 13.X
> >> to ver 15.X
> >> *ASIS-existing server = EC2 with Community PostgreSQL Ver 13.16.2*
> >> - ensure to capture all the pre.req meant for ver 15.10 are being
> >> met.
> >> - shutdown db.
> >> - take offline full backup (PG_DATA folder alone) using OS command
> >>
> >> *Proposed-new EC2 server (with new Operating System version along
> >> Postgres Ver 15.10 Binaries)*
> >> - install postgres 15.10 binaries
> >> - ensure to DISABLE auto startup and shutdown of postgres 15.10
> >> - Restore offline full backup (PG_DATA folder alone) using OS
> >> command
> >> - start performing pg_upgrade step to upgrade postgres from ver
> >> 13.16.2 to 15.10
> >>
> >> please guide me, if i have missed any steps in the abovesaid process
> >>
> >> To start new DB features, planning to rollout out the following
> >> feature's alone
> >> a) TLE extension for password compliance
> >> b) parallelize vacuum jobs to utilize -j option
> >>
> >>
> >> To migrate from one server to another while upgrading, one must use
> >> pg_dump/pg_restore OR Logical Replication.
> >
> > Really?
> >
> > Then this:
> >
> > https://www.postgresql.org/docs/current/pgupgrade.html
> <https://www.postgresql.org/docs/current/pgupgrade.html>
> >
> > must be random nose.
>
> Oh yeah, that was smooth.
>
> Second attempt:
>
> ... must be random noise.
>
>
> >
> >>
> >> --
> >> Death to <Redacted>, and butter sauce.
> >> Don't boil me, I'm still alive.
> >> <Redacted> lobster!
> >
>
> --
> Adrian Klaver
> adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
