From: Euler Taveira <euler@eulerto.com>
To: Jorge Soro Domenech <jorsodom@gmail.com>
To: pgsql-bugs@postgresql.org
Subject: Re: Help pg_restore version
Date: Sun, 01 Oct 2023 10:29:45 -0300
Message-ID: <2f159007-fe3c-4176-9a73-be19ccd96fe2@app.fastmail.com> (raw)
In-Reply-To: <CAGqiXh+6GTEbcc6+33=dQkqKw4hwxpMODQC_AiVbGyDQbUELTQ@mail.gmail.com>
References: <CAGqiXh+6GTEbcc6+33=dQkqKw4hwxpMODQC_AiVbGyDQbUELTQ@mail.gmail.com>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: euler@eulerto.com, jorsodom@gmail.com
Subject: Re: Help pg_restore version
In-Reply-To: <2f159007-fe3c-4176-9a73-be19ccd96fe2@app.fastmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox