From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Krishnaswamy <krishpostgresql@gmail.com>
To: Chris Hoover <chrish@aweber.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Postgres upgrade from 9.6.9 to postgresql 16 version
Date: Fri, 16 Feb 2024 13:33:48 +0100
Message-ID: <d7b941c7152c1e739701ecd70773fc25d2ea91e5.camel@cybertec.at> (raw)
In-Reply-To: <CAE6DLLJAc8pTBUyBP1_v-21BBGr7bVz=4Scd6WSf1S6dEYU=Fg@mail.gmail.com>
References: <CAE6DLL+Y6T98BoEqjpjEzQRTnpREWdqRxDM23zhv+Shd5Mt_4g@mail.gmail.com>
<A216A31D-E83F-4C75-A5B8-6982E7450CD4@aweber.com>
<CAE6DLLJAc8pTBUyBP1_v-21BBGr7bVz=4Scd6WSf1S6dEYU=Fg@mail.gmail.com>
On Fri, 2024-02-16 at 13:27 +0530, Krishnaswamy wrote:
> As per the documentation wal_level= logical supported in 9.6 version.
>
> Can we use logical replication in that use to upgrade.
>
> But the issue here is test_decoding plugin seems to be missing in the library..
> is it possible to install manually the plugin...please let me know any refer
> links or steps for that....
You cannot use logical replication with version 9.6.
test_decoding is just for testing and cannot help with logical replication.
Yours,
Laurenz Albe
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: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, krishpostgresql@gmail.com, chrish@aweber.com, pgsql-admin@lists.postgresql.org
Subject: Re: Postgres upgrade from 9.6.9 to postgresql 16 version
In-Reply-To: <d7b941c7152c1e739701ecd70773fc25d2ea91e5.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox