Need help

On 12/29/23 6:02 AM, 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?

<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