Re: Postgres upgrade from 9.6.9 to postgresql 16 version

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Krishnaswamy <krishpostgresql(at)gmail(dot)com>, Chris Hoover <chrish(at)aweber(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Postgres upgrade from 9.6.9 to postgresql 16 version
Date: 2024-02-16 12:33:48
Message-ID: d7b941c7152c1e739701ecd70773fc25d2ea91e5.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Teju Jakkidi vlogs 2024-02-17 20:33:45 pg_hba.conf settings for postgres
Previous Message Krishnaswamy 2024-02-16 07:57:24 Re: Postgres upgrade from 9.6.9 to postgresql 16 version