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 1v29c2-000pge-07 for pgsql-general@arkaria.postgresql.org; Fri, 26 Sep 2025 14:39:54 +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 1v29bz-002OeH-E5 for pgsql-general@arkaria.postgresql.org; Fri, 26 Sep 2025 14:39:52 +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 1v29bz-002Oe8-37 for pgsql-general@lists.postgresql.org; Fri, 26 Sep 2025 14:39:51 +0000 Received: from mail-oo1-xc2f.google.com ([2607:f8b0:4864:20::c2f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v29bw-0002bp-2z for pgsql-general@postgresql.org; Fri, 26 Sep 2025 14:39:50 +0000 Received: by mail-oo1-xc2f.google.com with SMTP id 006d021491bc7-62189987b47so1445144eaf.1 for ; Fri, 26 Sep 2025 07:39:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1758897588; x=1759502388; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=Vlx4nay1hx6j7ccDxI2k//PWzQQdcmtKZpLmpAXmRVM=; b=V/xB02W9Un9OwnVNU68BSZ71nHRGKw2jkRpv5xkXCqGrS95QXPWMASBfDcwULenQY4 hlIS4GsnFtz2P53s0eviUb5keRLpPnLu7wHn274h7zjyR9IabpGq93IGtV4B5EQkRlSo zWsCl34yrwS7jtQgVro46ZzzGXAbVq77+JfsVEN30EyHNMIbFTF02hRNzkCUjY670hV7 6GorhagHAt/auxcWubFbNMdl9kVLSDyGk5dVMB+ZXl9ta/V3mkxL5Nqtux/lOXJbfLyJ y1JabQuSGDY1ncuDmygceXNiP10stnTLsPCx/gaasR12IGVm56BpAE6j7u1HC3XJcF6k FGLw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1758897588; x=1759502388; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=Vlx4nay1hx6j7ccDxI2k//PWzQQdcmtKZpLmpAXmRVM=; b=mWU39hkyGObKmHZb+nzq2/Re2jKBs5g6b7agswyzn2Q/20dEQ8zdcIscFyKEGZGnpW i8DffNbQBp9QDL0T/iZzQMjdMbxepHFBCYy74MNW8LmCJHvtaHfFfepUQISmJwXsj8w0 77WQHq9uxNgxM2msG5aIQNiCWb3AKQB/hbzX3jVkilU/Fti9BklNZ6Iu+EbUmajXlPod V/9lWkHRiTQ+9O/ef9mxjjKD1URk1BTFVwBk3RThQ5rtKJHM7ZPPZ1nVqpVdQ/cjderZ eEi/EGXMXh0PUkdkfxOGnqm2x3SLozkipG5vMljD29WxqRpA38trm+EmATU5PcknhZO8 fY9Q== X-Gm-Message-State: AOJu0YxZmhnoW6d6K2owAT5RSWhsoe+pMZeTX5ndozkRYvPnrzjtnXtc +6uLxM1Hr3UTtr9Bo79X6MSdlRMTAmph2Hpa8CAAifUIQye6x9eZmqkxGj9HUbkFLFINjwzFsfW MuaJfSUuXFcOqQ5zlaBBQtukjg7+dIU2/BKtg X-Gm-Gg: ASbGnctF1rY3nWJbMW29g9kEmZZzb41YG+aJycfAlqTWH2nwC0KB/Ywurcj5igJPWN0 EtNVL9HEPplvR9dItCmxKe60eeHtYnQp4UzE8OZVk/u77klCASQaNDAQVk4lxQbBWB53lnfck6Q Gw8aDQv2yHsHYjj4G9D2hMrSEz51ERlz3DtMJ6PCEgNH2GD90UI/IBdDDsMNLIuHYih3RRe0nIE r09SVLuHprX58KX6ASMEmEt6QFT8w== X-Google-Smtp-Source: AGHT+IGHqt0gZzn0gxYouX0GZyvGqfM12zDO+QYg8MziUYdIppr7kijR4vHPAEMK7ineJ+7bOIWbRz7nkMvXPc1Naeo= X-Received: by 2002:a05:6808:228a:b0:43d:490b:a07d with SMTP id 5614622812f47-43f4cea340emr1795448b6e.35.1758897588431; Fri, 26 Sep 2025 07:39:48 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Fri, 26 Sep 2025 10:39:37 -0400 X-Gm-Features: AS18NWAihhgsdXSZ-cxSDkQXziCojULXOxTV7qke1GcEhDKPn49wWflJzdH9bjk Message-ID: Subject: Re: Downgrade pgsql 17 to pgsql 12 question To: pgsql-general Content-Type: multipart/alternative; boundary="000000000000f46ee8063fb54168" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f46ee8063fb54168 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Fri, Sep 26, 2025 at 10:27=E2=80=AFAM Laurenz Albe wrote: > On Fri, 2025-09-26 at 17:48 +0530, Ashish Mukherjee wrote: > [snip] > > pg_restore: error: while PROCESSING TOC: > > error: pg_restore: error: pg_restore: from TOC entry 17168; 1259 > 58572315 TABLE pkgs s14 > > pg_restore: error: pg_restore: pg_restore: pg_restore: from TOC entry > 17168; 1259 58572315 TABLE pkgs s14 > > pg_restore: error: pg_restore: from TOC entry 17168; 1259 58572315 > TABLE pkgs s14 > > pg_restore: error: pg_restore: from TOC entry 17168; 1259 58572315 TABL= E > pkgs s14 > > error: from TOC entry 17168; 1259 58572315 TABLE pkgs s14 > > pg_restore: warning: errors ignored on restore: 2 > > > > pkgs is the table and s14 is my database > > There should be more: the actual error messages. These will give you a > clue. > Probably in the log_directory log file. --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000f46ee8063fb54168 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Fri, Sep 26, 2025 at 10:27=E2=80=AFAM = Laurenz Albe <laurenz.albe@c= ybertec.at> wrote:
On Fri, 2025-09-26 a= t 17:48 +0530, Ashish Mukherjee wrote:
[snip]=C2=A0
> pg_restore: error: while PROCESSING TOC:
> =C2=A0error: pg_restore: =C2=A0error: =C2=A0 pg_restore: =C2=A0from TO= C entry 17168; 1259 58572315 TABLE pkgs s14
> pg_restore: error: pg_restore: pg_restore: pg_restore: =C2=A0 from TOC= entry 17168; 1259 58572315 TABLE pkgs s14
> pg_restore: =C2=A0 error: pg_restore: from TOC entry 17168; 1259 58572= 315 TABLE pkgs s14
> pg_restore: error: pg_restore: from TOC entry 17168; 1259 58572315 TAB= LE pkgs s14
> error: from TOC entry 17168; 1259 58572315 TABLE pkgs s14
> pg_restore: warning: errors ignored on restore: 2
>
> pkgs is the table and s14 is my database

There should be more: the actual error messages.=C2=A0 These will give you = a clue.

Probably in th= e log_directory log file.

--
Death to <Redacted>, and butter sauce.
Don't boil me= , I'm still alive.
<Redacted> lobster!
--000000000000f46ee8063fb54168--