From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ashish Mukherjee <ashish.mukherjee@gmail.com>
cc: pgsql-general@postgresql.org
Subject: Re: Downgrade pgsql 17 to pgsql 12 question
In-reply-to: <CACgMzfxO7h+Bj4T8rjTV=trM3+Uw=jOAcUE+0Kimv4DSAVU1JA@mail.gmail.com>
References: <CACgMzfxO7h+Bj4T8rjTV=trM3+Uw=jOAcUE+0Kimv4DSAVU1JA@mail.gmail.com>
Comments: In-reply-to Ashish Mukherjee <ashish.mukherjee@gmail.com>
	message dated "Fri, 26 Sep 2025 17:48:07 +0530"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <4089347.1758905461.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Fri, 26 Sep 2025 12:51:01 -0400
Message-ID: <4089348.1758905461@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/4089348.1758905461%40sss.pgh.pa.us>
Precedence: bulk

Ashish Mukherjee <ashish.mukherjee@gmail.com> writes:
> When I do dump/restore like this for a test table, I get the following
> errors during restore but the table gets restored fine.

> 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 TAB=
LE
> pkgs s14
> pg_restore: error: pg_restore: from TOC entry 17168; 1259 58572315 TABLE
> pkgs s14
> error: from TOC entry 17168; 1259 58572315 TABLE pkgs s14
> pg_restore: warning: errors ignored on restore: 2

FWIW, the only output I see when trying a simple restore of a couple
of tables from HEAD into a v12 server is

pg_restore: error: could not execute query: ERROR:  unrecognized configura=
tion parameter "transaction_timeout"
Command was: SET transaction_timeout =3D 0;
pg_restore: warning: errors ignored on restore: 1

which is expected since v12 didn't have transaction_timeout.
(If you use parallel mode you will see this error per-worker.)

This means you can't use --single-transaction, but it should
work otherwise as long as you're not using DDL features v12
didn't have.

So I'm wondering why your output doesn't show that, and also
why it fails to show the text of whatever error you are getting.
Can you make a reproducible test case that behaves like that?

			regards, tom lane