Re: Help pg_restore version - Mailing list pgsql-bugs

From Euler Taveira
Subject Re: Help pg_restore version
Date
Msg-id 2f159007-fe3c-4176-9a73-be19ccd96fe2@app.fastmail.com
Whole thread Raw
In response to Help pg_restore version  (Jorge Soro Domenech <jorsodom@gmail.com>)
Responses Re: Help pg_restore version  (Jorge Soro Domenech <jorsodom@gmail.com>)
List 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

pgsql-bugs by date:

Previous
From: Shubham Gholap
Date:
Subject: Bug in postgresql related column level security authentication.
Next
From: Joe Conway
Date:
Subject: Re: BUG #18141: sorry, too many clients error occurring very frequently