Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rv55V-009ZCC-TK for pgsql-hackers@arkaria.postgresql.org; Fri, 12 Apr 2024 00:48:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rv55T-007ct6-IZ for pgsql-hackers@arkaria.postgresql.org; Fri, 12 Apr 2024 00:48:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rv55T-007cqZ-6k for pgsql-hackers@lists.postgresql.org; Fri, 12 Apr 2024 00:48:15 +0000 Received: from mail-ej1-x62f.google.com ([2a00:1450:4864:20::62f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rv55P-002QT2-5p for pgsql-hackers@lists.postgresql.org; Fri, 12 Apr 2024 00:48:13 +0000 Received: by mail-ej1-x62f.google.com with SMTP id a640c23a62f3a-a51969e780eso45127066b.3 for ; Thu, 11 Apr 2024 17:48:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1712882889; x=1713487689; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=4zjoFW4ZfNkv32EM0HSJ0ruAuoIOWbUNgJkK0U4rUPc=; b=Oq5t2R4zpEe1Ht06YioZ+2A4l4eOc7VNcytWXpPVINgFYy2ksRteKjaJt6vT0a011R hE/l/yV7FF7x7Xr4gsvhdrly8wnNVish8O4RlLa0d+ZVMm5WyT98xFoPyRLxRruG2YHf I+9NuiRxhzSfdxUZE7GOFwr4ry/gvdN8Jhn5rX5+/F28g28piaunrFBPu7Yw5YhY7jc6 dPfDu/1241y8oMu2XuDj5GhAeiMz1LynLz8gHxwHsGOlQ+o3Ni7hHCk8ESRtz2ZvaFbS E1fwW7Sf4hxmdAPZVJsN8pJNqeX8TaT5jtHav1OV3J7IldSVQe3dyyuaqijBgP1mHtQ8 nzyg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1712882889; x=1713487689; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=4zjoFW4ZfNkv32EM0HSJ0ruAuoIOWbUNgJkK0U4rUPc=; b=AzUYe3z+qvQyFr5TqTK81Xt2VQbPaxB8w2h68ZhF4Hlc+5zfn83ZUPgEvL8eJJrnNz IRe26yoYenzzRpn9t3Qh4ybJEZa+tCHHJhzOtEyYkb6rA2MNxWl1ORVa6ILkDajJDDzF MQZJx5yU4XIWhWkhEDM7KN1x74HVpJyciIKzPWEHktI7Fd1NakuNWjwpJgN/3HV+Wqtg 5zK2BNNdKNReIHMe/2hKyz8Q3H4WUdap7aiLZ2Tm4fOHEouhuq+QsSR6XQ7GykqWnGN1 kg0f5Sy7uayWp0fk1IQzUIGUqoSdeqQSUBdTFwb9JhWypsy4aqzbXpAEqmc7Lb6gWLGW vzzw== X-Gm-Message-State: AOJu0YyX835DIB4PzyMuzE3fhzGLJN2F2HEk1U4gDzCIG8S5eSq/daoB Y6ppjpZ/Ay8pUVuTTn/hh9vm1bP8hM4BIr8mCdYKnusJvYN+fgnbSp+fw88STwgrPravLelAj3V kV61ePJ+2llaZxWa3UAImiX5PrlIyiD2o X-Google-Smtp-Source: AGHT+IEqQMyCrgBXl3TqutgR26+Z7lDUjFEkXY+/h78FkJ07vmpPz5F3sE8KCYoBzU9FZmL34R/NdWliJULBypZZWVY= X-Received: by 2002:a17:906:c252:b0:a51:e451:6f3 with SMTP id bl18-20020a170906c25200b00a51e45106f3mr686863ejb.23.1712882888828; Thu, 11 Apr 2024 17:48:08 -0700 (PDT) MIME-Version: 1.0 From: Perumal Raj Date: Thu, 11 Apr 2024 17:47:57 -0700 Message-ID: Subject: pg_upgrde failed : logical replication : alter_subscription_add_log To: pgsql-hackers@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000216bfc0615dba0a3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000216bfc0615dba0a3 Content-Type: text/plain; charset="UTF-8" Hi Community I am trying to upgrade PostgreSQL (RHEL 7) from version 13.7 to 15.6 using pglogical. My Standby(destination) machine has following rpms, *postgresql13-pglogical-3.7.16-1.el7.x86_64pglogical_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_subscription_add_log("text", "text", boolean, "regclass", "text"[], "text"[]) postgres pg_restore: error: could not execute query: ERROR: could not find function "pglogical_alter_subscription_add_log" in file "/usr/pgsql-15/lib/pglogical.so" Command was: CREATE FUNCTION "pglogical"."alter_subscription_add_log"("sub_name" "text", "log_name" "text", "log_to_file" boolean DEFAULT true, "log_to_table" "regclass" DEFAULT NULL::"regclass", "conflict_type" "text"[] DEFAULT 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? Thanks, --000000000000216bfc0615dba0a3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Community

I am trying to upgrade PostgreSQL (RHE= L 7) from version 13.7 to 15.6 using pglogical.
My Standby(destination) = machine has following rpms,

postgresql13-pglogical-3.7.16-1.el= 7.x86_64
pglogical_15-2.4.3-1.rhel7.x86_64

And Primary(So= urce) has ,

postgresql13-pglogical-3.7.16-1.el7.x86_64
pg_upgrade check mode went fine , but it failed while r= unning real mode.

pg_restore: while PROCESSI= NG TOC:
pg_restore: from TOC entry 13027; 1255 3375648004 FUNCTION alter= _subscription_add_log("text", "text", boolean, "re= gclass", "text"[], "text"[]) postgres
pg_restor= e: error: could not execute query: ERROR: =C2=A0could not find function &qu= ot;pglogical_alter_subscription_add_log" in file "/usr/pgsql-15/l= ib/pglogical.so"
Command was: CREATE FUNCTION "pglogical"= ."alter_subscription_add_log"("sub_name" "text&quo= t;, "log_name" "text", "log_to_file" boolean = DEFAULT true, "log_to_table" "regclass" DEFAULT NULL::&= quot;regclass", "conflict_type" "text"[] DEFAULT N= ULL::"text"[], "conflict_resolution" "text"[]= DEFAULT NULL::"text"[]) RETURNS boolean
=C2=A0 =C2=A0 LANGUAG= E "c"
=C2=A0 =C2=A0 AS '$libdir/pglogical', 'pglog= ical_alter_subscription_add_log';

-- For binary upgrade, handle = extension membership the hard way
ALTER EXTENSION "pglogical" = ADD FUNCTION "pglogical"."alter_subscription_add_log"(&= quot;sub_name" "text", "log_name" "text"= , "log_to_file" boolean, "log_to_table" "regclass&= quot;, "conflict_type" "text"[], "conflict_resolut= ion" "text"[]);

Am I missing any packages?
=

Thanks,
--000000000000216bfc0615dba0a3--