MIME-Version: 1.0
References: <CALvqh4r3zMTeD941M0BuXQ3C=4DgzvnxDSnrstjsoHnqiv4mqQ@mail.gmail.com>
In-Reply-To: <CALvqh4r3zMTeD941M0BuXQ3C=4DgzvnxDSnrstjsoHnqiv4mqQ@mail.gmail.com>
From: Amit Kapila <amit.kapila16@gmail.com>
Date: Fri, 12 Apr 2024 08:38:38 +0530
Message-ID: <CAA4eK1+2gWCRgODkv=Zvg99WJE+CCfrcHmCY9JQX7tc-VaKQjg@mail.gmail.com>
Subject: Re: pg_upgrde failed : logical replication : alter_subscription_add_log
To: Perumal Raj <perucinci@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAA4eK1%2B2gWCRgODkv%3DZvg99WJE%2BCCfrcHmCY9JQX7tc-VaKQjg%40mail.gmail.com>
Precedence: bulk

On Fri, Apr 12, 2024 at 6:18=E2=80=AFAM Perumal Raj <perucinci@gmail.com> w=
rote:
>
> I am trying to upgrade PostgreSQL (RHEL 7) from version 13.7 to 15.6 usin=
g pglogical.
> My Standby(destination) machine has following rpms,
>
> postgresql13-pglogical-3.7.16-1.el7.x86_64
> pglogical_15-2.4.3-1.rhel7.x86_64
>
> And Primary(Source) has ,
>
> postgresql13-pglogical-3.7.16-1.el7.x86_64
>
> pg_upgrade check mode went fine , but it failed while running real mode.
>
> pg_restore: while PROCESSING TOC:
> pg_restore: from TOC entry 13027; 1255 3375648004 FUNCTION alter_subscrip=
tion_add_log("text", "text", boolean, "regclass", "text"[], "text"[]) postg=
res
> pg_restore: error: could not execute query: ERROR:  could not find functi=
on "pglogical_alter_subscription_add_log" in file "/usr/pgsql-15/lib/pglogi=
cal.so"
> Command was: CREATE FUNCTION "pglogical"."alter_subscription_add_log"("su=
b_name" "text", "log_name" "text", "log_to_file" boolean DEFAULT true, "log=
_to_table" "regclass" DEFAULT NULL::"regclass", "conflict_type" "text"[] DE=
FAULT NULL::"text"[], "conflict_resolution" "text"[] DEFAULT NULL::"text"[]=
) RETURNS boolean
>     LANGUAGE "c"
>     AS '$libdir/pglogical', 'pglogical_alter_subscription_add_log';
>
> -- For binary upgrade, handle extension membership the hard way
> ALTER EXTENSION "pglogical" ADD FUNCTION "pglogical"."alter_subscription_=
add_log"("sub_name" "text", "log_name" "text", "log_to_file" boolean, "log_=
to_table" "regclass", "conflict_type" "text"[], "conflict_resolution" "text=
"[]);
>
> Am I missing any packages?
>

We don't maintain pglogical so difficult to answer but looking at the
error (ERROR:  could not find function
"pglogical_alter_subscription_add_log" in file
"/usr/pgsql-15/lib/pglogical.so"), it seems that the required function
is not present in pglogical.so. It is possible that the arguments
would have changed in newer version of pglogical or something like
that. You need to check with the maintainers of pglogical.

--=20
With Regards,
Amit Kapila.