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.96) (envelope-from ) id 1wOwb0-000IkI-2r for pgsql-novice@arkaria.postgresql.org; Mon, 18 May 2026 11:57:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wOway-0025bp-1c for pgsql-novice@arkaria.postgresql.org; Mon, 18 May 2026 11:57:17 +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.96) (envelope-from ) id 1wOway-0025bh-01 for pgsql-novice@lists.postgresql.org; Mon, 18 May 2026 11:57:17 +0000 Received: from mx1.alte-leipziger.de ([91.217.145.231]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wOwav-00000000AOx-1QD0 for pgsql-novice@lists.postgresql.org; Mon, 18 May 2026 11:57:15 +0000 X-CSE-ConnectionGUID: TFoUu0hgRnibNQ8W25ZStA== X-CSE-MsgGUID: 15X0wRubTwW0sFGN4qyS7w== From: "Subramanian,Ramachandran" To: "pgsql-novice@lists.postgresql.org" Subject: pg_restore error Thread-Topic: pg_restore error Thread-Index: AdzmvQaNRNfjqbfCQ4qe2ijnFLwrFA== Date: Mon, 18 May 2026 11:57:06 +0000 Message-ID: Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-tmase-matchedrid: ri4i9W2begoQjUlvvymmXqODSWu0oxbKxQcr4E6BPnWr3xR+nslJgOuY 9eXer3/Uc2m8ZFmiw7OJxfLTUElavJfB/yY7LwJuo9EpvYCLf52bHMOLlW98GFO0wcTortdTYDt tQUGqHZU= x-tm-as-user-approved-sender: No x-tm-as-user-blocked-sender: No x-tmase-result: 10--5.490600-8.000000 x-tm-snts-smtp: 73F5A36420179142D9325FA7D71BA090E400C799EAF5DBF6782EC0C27FF541872000:8 x-alsentwithgood: false Content-Type: multipart/alternative; boundary="_000_c317a2a56cdc4ce4b0bb6e964dfc47b0alteleipzigerde_" MIME-Version: 1.0 X-GBS-PROC: HdXKzbHBUujujSc7GbdoHuXSWc4p2uS27sXPHEDJJcjoLZ/QNTdJRRLGFcfvh7dG X-GBS-PROCJOB: =?utf-8?Q?kR2Tx5HFRUnCt69AYId0Pt/M6DeHh9QQHyTH7ZqzeDh+H9XYkj9px9yiwoZK?= =?utf-8?Q?Zjar181L6PgJy2kwy5wYyJ/HmwEtcZtxpssT5lMOAvA/ZbHOuf1L+v2/SU6n?= =?utf-8?Q?pdEkGFTIv6DJCi7qHEdbV6HpxJhMMKdWgfgNnoDKOcRQ8sD7XfI=3D?= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_c317a2a56cdc4ce4b0bb6e964dfc47b0alteleipzigerde_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I received a file to be restored into a new box. I tried to do a psql -f and postgres asked me to use pg_restore instead= . Then I used pg_restore and got this error message. pg_restore -c -v -f Restore.out Cameleon_ewt_20260512.sql pg_restore: error: unsupported version (1.16) in file header I am running postgres 16.13 . How should I handle this issue=3F Would be grateful for your inputs. LG Ram [postgres@lx90189 postgresql]$ head -10 Cameleon_ewt_20260512.sql PGDM7 ~data16.8 (Debian 16.8-1.pgdg120+1)18.1=3F=27%[0ENCODINENCODINGSET client= _encoding =3D =27UTF8=27; false&[00 STDSTRINGS STDSTRINGS(SET standard_conforming_strings =3D =27on=27; false=27[00 SEARCHPATH SEARCHPATH8SELECT pg_catalog.set_config(=27search_path=27, =27=27, false)= ; false([126221992datDATABASEoCREATE DATABASE data WITH TEMPLATE =3D templa= te0 ENCODING =3D =27UTF8=27 LOCALE_PROVIDER =3D libc LOCALE =3D =27en_US.= utf8=27; DROP DATABASE data; = = postgresfalse=2726154653= 312197261SCHEMACREATE SCHEMA =222197261=22; [postgres@lx90189 postgresql]$ xtermxtermxtermxtermxterm Freundliche Gr=FC=DFe i. A. Ramachandran Subramanian Zentralbereich Informationstechnologie Alte Leipziger Lebensversicherung a.G. Hallesche Krankenversicherung a.G. Alte Leipziger Lebensversicherung a.G., Alte Leipziger-Platz 1, 61440 Obe= rursel Vors. des Aufsichtsrats: Dr. Walter Botermann =B7 Vorstand: Christoph Boh= n (Vors.), Dr. J=FCrgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Joche= n Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcs= ek Sitz Oberursel (Taunus) =B7 Rechtsform VVaG =B7 Amtsgericht Bad Homburg v= . d. H. HRB 1583 =B7 USt.-IdNr. DE 114106814 =20 Hallesche Krankenversicherung a.G., L=F6ffelstra=DFe 34-38, 70597 Stuttg= art Vors. des Aufsichtsrats: Dr. Walter Botermann =B7 Vorstand: Christoph Boh= n (Vors.), Dr. J=FCrgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Joche= n Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek Sitz Stuttgart =B7 Rechtsform VVaG =B7 Amtsgericht Stuttgart HRB 2686 = =B7 USt.-IdNr. DE 147802285 Beitr=E4ge zu privaten Kranken- und Pflegekrankenversicherungen unterlieg= en nicht der Versicherungsteuer (=A7 4 Nr. 5 VersStG) =B7 Versicherungsle= istungen sowie Ums=E4tze aus Versicherungsvertreter-/Maklert=E4tigkeiten = sind umsatzsteuerfrei =20 =20 Die Pflichtangaben der ALH Gruppe gem=E4=DF =A7 35a GmbHG bzw. =A7 80 Akt= G finden Sie hier: https://www.alte-leipziger.de/impressum=20 ______________________ ALH Gruppe Alte Leipziger-Platz 1, 61440 Oberursel Tel.: +49 (6171) 66-4882 Fax: +49 (6171) 66-800-4882 E-Mail: ramachandran.subramanian@alte-leipziger.de www.alte-leipziger.de www.hallesche.de --_000_c317a2a56cdc4ce4b0bb6e964dfc47b0alteleipzigerde_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello,

 

  I received a file to be restored into a= new box.

 

I tried to do a psql -f   and postgr= es asked me to use pg_restore instead.

 

 

Then I used pg_restore and got this error mess= age.

 

pg_restore -c -v -f Restore.out Cameleon_ewt_2= 0260512.sql

 

pg_restore: error: unsupported version (1.16) = in file header

 

 

I am running postgres 16.13 . 

 

How should I handle this issue=3F

 

Would be grateful for your inputs.<= /span>

 

 

LG

 

Ram

 

 

 

[postgres@lx90189 postgresql]$ head -10 Camele= on_ewt_20260512.sql

PGDM7

~data16.8 (Debian 16.8-1.pgdg120+1)18.1 = 618;=27%[0ENCODINENCODINGSET client_encoding =3D =27UTF8=27;

false&[00

STDSTRINGS

STDSTRINGS(SET standard_conforming_strings = =3D =27on=27;

false=27[00

SEARCHPATH

SEARCHPATH8SELECT pg_catalog.set_config(=27sea= rch_path=27, =27=27, false);

false([126221992datDATABASEoCREATE DATABASE da= ta WITH TEMPLATE =3D template0 ENCODING =3D =27UTF8=27 LOCALE_PROVIDER = =3D libc LOCALE =3D =27en_US.utf8=27;

DROP DATABASE data;    &nb= sp;           &nbs= p;            = ;            =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ; postgresfalse=2726154653312197261SCHEMACREATE SCHEMA "2197261"= ;

[postgres@lx90189 postgresql]$ xtermxtermxterm= xtermxterm


Freundliche Gr=FC=DFe


i. A. Ramachandran Subrama= nian =20

Zentralbereich Informationst= echnologie

=20

Alte Leipziger Lebensversicherung a. G.<= /SPAN>

Hallesche Krankenversicherung a. G.

=20

______________________

ALH Gruppe
Alte Leipziger-Platz 1, 614= 40 Oberursel
Tel: +49 (6171) 66-4882
Fax: +49 (6171) 66-800-4882E-Mail: ramachandran.subramanian@alte-leipziger.de
www.alte-leipziger.de
www.hallesche.de

Alte Leipziger Lebensversich= erung a. G., Alte Leipziger-Platz 1, 61440 Oberursel

Vors. des Aufsichtsra= ts: Dr. Walter Botermann =B7 Vorstand: Christoph Bohn (Vors.), Dr. J=FCrg= en Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexand= er Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek

Sitz Oberursel (Taunus) =B7 = Rechtsform VVaG =B7 Amtsgericht Bad Homburg v. d. H. HRB 1583 =B7 USt.-Id= Nr. DE 114106814


Hallesche Krankenversicherun= g a. G., L=F6ffelstra=DFe 34-38, 70597 Stuttgart

Vors. des Aufsichtsrats: Dr.= Walter Botermann =B7 Vorstand: Christoph Bohn (Vors.), Dr. J=FCrgen Bier= baum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexander Maye= r, Christian Pape, Wiltrud Pekarek, Udo Wilcsek

Sitz Stuttgart =B7 Rechtsfor= m VVaG =B7 Amtsgericht Stuttgart HRB 2686 =B7 USt.-IdNr. DE 147802285

Beitr=E4ge zu privaten Krank= en- und Pflegekrankenversicherungen unterliegen nicht der Versicherungste= uer (=A7 4 (1) Nr. 5 b VersStG) =B7 Versicherungsleistungen sowie Ums=E4t= ze aus Versicherungsvertreter-/Maklert=E4tigkeiten sind umsatzsteuerfrei<= /SPAN>


= Pflichtangaben der A= LH Gruppe gem=E4=DF =A7 35a GmbHG bzw. =A7 80 AktG --_000_c317a2a56cdc4ce4b0bb6e964dfc47b0alteleipzigerde_--