On 12/29/23 21:21, ankit.singh@xxxxxxxxxxxx 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@xxxxxxxxxxx>
*Sent:* 30 December 2023 00:45
*To:* ankit.singh@xxxxxxxxxxxx; pgsql-general@xxxxxxxxxxxxxxxxxxxx
*Subject:* Re: Need help
On 12/29/23 6:02 AM, ankit.singh@xxxxxxxxxxxx
<mailto:ankit.singh@xxxxxxxxxxxx> 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@xxxxxxxxxxx
