Re: Need help

On 12/29/23 21:21, ankit(dot)singh(at)nest-is2(dot)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(dot)klaver(at)aklaver(dot)com>
> *Sent:* 30 December 2023 00:45
> *To:* ankit(dot)singh(at)nest-is2(dot)com; pgsql-general(at)lists(dot)postgresql(dot)org
> *Subject:* Re: Need help
>
> On 12/29/23 6:02 AM, ankit(dot)singh(at)nest-is2(dot)com
> <mailto:ankit(dot)singh(at)nest-is2(dot)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(dot)klaver(at)aklaver(dot)com