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 1qmwWY-009Wue-BG for pgsql-bugs@arkaria.postgresql.org; Sun, 01 Oct 2023 13:30:19 +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 1qmwWV-00Bhvp-1Y for pgsql-bugs@arkaria.postgresql.org; Sun, 01 Oct 2023 13:30: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 1qmwWT-00Bhul-JE for pgsql-bugs@lists.postgresql.org; Sun, 01 Oct 2023 13:30:14 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qmwWQ-007c93-4r for pgsql-bugs@postgresql.org; Sun, 01 Oct 2023 13:30:12 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.47]) by mailout.west.internal (Postfix) with ESMTP id EAA7032012DE; Sun, 1 Oct 2023 09:30:07 -0400 (EDT) Received: from imap49 ([10.202.2.99]) by compute6.internal (MEProxy); Sun, 01 Oct 2023 09:30:08 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eulerto.com; h= cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm3; t=1696167007; x=1696253407; bh=sA D+/j66Xp4LPJ5RRoRSGCLa6St6RrW0LiRiA3FuUpU=; b=Ks8Jak4DsigjcP6665 NRT8MFIDjyr/plwdOqHXWACYAT3DVlXnufeCbqSLYG/4dAg8/WBdN0m5IQ+VI9xq uMl9as/WuwW/LhwDnTKoj2wOuv23Eq3igW6oTfcJNwX0GJz96hdso24kG7Cs69Ug LzU47k5UX+LRim23AD7Brvhky0XeClnZQJ8yyfRZQxCEjemGl3C8QIbKlP/rDMVh uOG3lEw1pZuGuq3wWke2CgyL0YqxW6FIIdceipXHtdvaJHeIE7tu0yR9YkkrZx9V F72sYxMvwB9a7ii24vpYY7YKGi7A2E5dA1V4SpY5WbNPfalmdgc3Rl10bfxFA57o DB0Q== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm2; t=1696167007; x=1696253407; bh=sAD+/j66Xp4LP J5RRoRSGCLa6St6RrW0LiRiA3FuUpU=; b=bLd98zyf8wd1qBGpy5QgfdGhtzX3R HM/wkUgEeoOK8kJYcKPmPHDRvQF5un2dYyhph6w3eCHTagAn+4nv/7nlPQ8oY+ZQ yTX5rZqXlqvRqs3VE4Na1K88wqN+DPQ//eizLTyTY8A7NEWrc+1KpEhQnjvF6U5L dC8LICt340ovvUk64WyAx688rYFARy4Y/5p3mbV4ZQuQeBT4F3fmwmZnJmv3SB4w K0ZHk2Uo5KFoI5XKIjY+GOWXp62R1ic2R1cID+IvVa3XVBMx8GrXs1T30I76RgrP ZAxB38uhN2UtS8d2oQLjBnYH6jV67vM8l2t7A9RQr1cy/WaZ1COHM3JUA== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrvddugddtfecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecunecujfgurhepofgfggfkjghffffhvffutgesrgdtre erreertdenucfhrhhomhepfdfguhhlvghrucfvrghvvghirhgrfdcuoegvuhhlvghrsegv uhhlvghrthhordgtohhmqeenucggtffrrghtthgvrhhnpeejtefhuedvgffftdetvedufe dtjeeuffekleevkefhveekgeelfefhjeehtdejgeenucffohhmrghinhepvghnthgvrhhp rhhishgvuggsrdgtohhmnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrg hilhhfrhhomhepvghulhgvrhesvghulhgvrhhtohdrtghomh X-ME-Proxy: Feedback-ID: i0c21471d:Fastmail Received: by mailuser.nyi.internal (Postfix, from userid 501) id 0824415A0091; Sun, 1 Oct 2023 09:30:07 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface User-Agent: Cyrus-JMAP/3.9.0-alpha0-958-g1b1b911df8-fm-20230927.002-g1b1b911d MIME-Version: 1.0 Message-Id: <2f159007-fe3c-4176-9a73-be19ccd96fe2@app.fastmail.com> In-Reply-To: References: Date: Sun, 01 Oct 2023 10:29:45 -0300 From: "Euler Taveira" To: "Jorge Soro Domenech" , pgsql-bugs@postgresql.org Subject: Re: Help pg_restore version Content-Type: multipart/alternative; boundary=967ddf2264b9490194cb9aaf1dedc507 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --967ddf2264b9490194cb9aaf1dedc507 Content-Type: text/plain On Sat, Sep 30, 2023, at 7:33 AM, Jorge Soro Domenech wrote: > But it show this error: You didn't show the error message but I suspect it is: pg_restore: [archiver] unsupported version (1.14) in file header As you showed the first bytes in the dump file, that first information (11.18) is the current Postgres version and the second one (15.2) is the pg_dump version that you used to create that dump file. Since old pg_dump version might not read a new format, you are getting this error. You can fix this issue using the pg_restore from version 15. PS> avoid images; prefer text error messages. It helps search engines to completely index this message so others can find this discussion. -- Euler Taveira EDB https://www.enterprisedb.com/ --967ddf2264b9490194cb9aaf1dedc507 Content-Type: text/html Content-Transfer-Encoding: quoted-printable
On Sat, Sep 30,= 2023, at 7:33 AM, Jorge Soro Domenech wrote:
But it show this error= :

You didn't show the er= ror message but I suspect it is:

pg_restore= : [archiver] unsupported version (1.14) in file header
As you showed the first bytes in the dump file, that first i= nformation (11.18)
is the current Postgres version and the= second one (15.2) is the pg_dump
version that you used to= create that dump file. Since old pg_dump version might
no= t read a new format, you are getting this error. You can fix this issue = using
the pg_restore from version 15.

PS> avoid images; prefer text error messages. It helps searc= h engines to
completely index this message so others can f= ind this discussion.


--
Euler Taveira
EDB   https://www.enterprisedb.com/

--967ddf2264b9490194cb9aaf1dedc507--