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\\00 00zulip\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