Thread: Need help

@font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;}span.EmailStyle17 {mso-style-type:personal-compose; font-family:"Calibri",sans-serif; color:windowtext;}.MsoChpDefault {mso-style-type:export-only; font-family:"Calibri",sans-serif; mso-ligatures:none; mso-fareast-language:EN-US;}div.WordSection1 {page:WordSection1;}

In Ubuntu 22.04LTS when we try to restore the database it's giving the error – pg restore unsupported 1.15

 

 

Needs  a lot more information:

1) Postgres version being restored to.

2) The complete pg_restore command.

3) The complete error message.

4) Where was Postgres installed from?

5) Do you have more then one version of Postgres installed?

<ankit.singh@nest-is2.com> writes:
> In Ubuntu 22.04LTS when we try to restore the database it's giving the error
> - pg restore unsupported 1.15

You need a version of pg_restore that's at least as new as
the pg_dump that made the archive file.  File version 1.15
I believe requires PG 16.

            regards, tom lane

On 12/29/23 21:21, ankit.singh@nest-is2.com wrote:
> Needs  a lot more information:
> 
> 1) Postgres version being restored to.--- *14.10*
> 
> 2)The complete pg_restore command. ---
> 
> */home/zulip/deployments/current/scripts/setup/restore-backup 
> /path/to/backup*
> 
> 3) The complete error message*.    PGDMP\\0000zulip\00"\00\00\0014.10 
> (Ubuntu 14.10-1.pgdg22.04+1)\00 \00\00\0016.1 (Ubuntu 
> 16.1-1.pgdg22.04+1)\0000ENCODING00SET client_encoding = 'UTF8';*


I'm not exactly sure what that error message is saying, though it is 
showing two different version of Postgres in use. Since pg_dump will not 
dump from a Postgres version newer then it's version, I'm going to say 
that you used the Postgres 16 version of pg_dump against the Postgres 14 
instance. Then used the Postgres 14 version of pg_restore to restore 
that dump file to the 14 instance. As Tom Lane mentioned that will not 
work as the older version(14) of pg_restore will not recognize the newer 
file version from the dump file(16). I don't have an answer for how you 
sort that out in the Zulip process.

> 
> **
> 
> 4) Where was Postgres installed from*?- Zulip server-6.1 I have 
> installed from that server I have taken backup*.**
> 
> 5) Do you have more then one version of Postgres installed? *14.10 & 
> 16.1 in server which I have taken backup*
> 
> **
> 
> *From:*Adrian Klaver <adrian.klaver@aklaver.com>
> *Sent:* 30 December 2023 00:45
> *To:* ankit.singh@nest-is2.com; pgsql-general@lists.postgresql.org
> *Subject:* Re: Need help
> 
> On 12/29/23 6:02 AM, ankit.singh@nest-is2.com 
> <mailto:ankit.singh@nest-is2.com> wrote:
> 
>     In Ubuntu 22.04LTS when we try to restore the database it's giving
>     the error – pg restore unsupported 1.15
> 
> Needs  a lot more information:
> 
> 1) Postgres version being restored to.
> 
> 2) The complete pg_restore command.
> 
> 3) The complete error message.
> 
> 4) Where was Postgres installed from?
> 
> 5) Do you have more then one version of Postgres installed?
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com

On 12/29/23 21:56, ankit.singh@nest-is2.com wrote:
> It's giving one more error please have a look.
> 

All that is telling you is that the underlying error you first reported 
"pg restore unsupported 1.15" caused one of the Zulip commands to fail.

The issue still remains that you have a mismatch between the file format 
of the dump file and the version of pg_restore you are using to attempt 
to restore that file. Until that gets sorted out you will not get any 
further.


-- 
Adrian Klaver
adrian.klaver@aklaver.com