Re: Need help - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Need help
Date
Msg-id e5c9de5a-96aa-4471-ac5d-edf6bd5933f3@aklaver.com
Whole thread Raw
In response to Need help  (<ankit.singh@nest-is2.com>)
List pgsql-general
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




pgsql-general by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Intermittent Issue with WAL Segment Removal in Logical Replication
Next
From: "Wilma Wantren"
Date:
Subject: Re: Re: Changing a schema's name with function1 calling function2