Re: Help pg_restore version

From: "Euler Taveira" <euler(at)eulerto(dot)com>
To: "Jorge Soro Domenech" <jorsodom(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Help pg_restore version
Date: 2023-10-01 13:29:45
Message-ID: 2f159007-fe3c-4176-9a73-be19ccd96fe2@app.fastmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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/

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Joe Conway 2023-10-01 14:34:15 Re: BUG #18141: sorry, too many clients error occurring very frequently
Previous Message Shubham Gholap 2023-10-01 07:59:17 Bug in postgresql related column level security authentication.