Re: Help pg_restore version - Mailing list pgsql-bugs

Hello Euler,

thank you for your response.

The backup file has generated external enterprise that me.

You said i try import it backup file with pg_restore version 15, its correct?

For a correct import, i need the version Postgree database i must have (11.18) version but i need a pg_restore version 15 for import this "bak file"

Its possible i have install Postgree database (11.18) and parallel i use only a pg_restore version 15?

My sistem is a redhat unix.

This is the header backup file.

PGDMP     %    6                {             a121_prd_md_483100    11.18    15.2     _            0    0    ENCODING    ENCODING        SET client_encoding = 'UTF8';

                           false              `            0    0 

   STDSTRINGS 

   STDSTRINGS     (   SET standard_conforming_strings = 'on';

                           false              a            0    0 

   SEARCHPATH 

   SEARCHPATH     8   SELECT pg_catalog.set_config('search_path', '', false);

                           false              b            1262    449003    a121_prd_md_483100    DATABASE        CREATE DATABASE a121_prd_md_483100 WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'English_United States.1252';

 "   DROP DATABASE a121_prd_md_483100;

                   yya121mstrmddb    false                            2615    2200    public    SCHEMA     2   -- *not* creating schema, since initdb creates it

 2   -- *not* dropping schema, since initdb creates it

                   yya121mstrmddb    false              ±            1255    449004    dssmdobjfunc()    FUNCTION     Ê   CREATE FUNCTION public.dssmdobjfunc() RETURNS trigger

    LANGUAGE plpgsql

    AS $$

El dom, 1 oct 2023 a las 15:30, Euler Taveira (<euler@eulerto.com>) escribió:

On Sat, Sep 30, 2023, at 7:33 AM, Jorge Soro Domenech wrote:

But it show this error:

You didn't show the error message but I suspect it is:

pg_restore: [archiver] unsupported version (1.14) in file header

As you showed the first bytes in the dump file, that first information (11.18)

is the current Postgres version and the second one (15.2) is the pg_dump

version that you used to create that dump file. Since old pg_dump version might

not read a new format, you are getting this error. You can fix this issue using

the pg_restore from version 15.

PS> avoid images; prefer text error messages. It helps search engines to

completely index this message so others can find this discussion.

--

Euler Taveira

EDB   https://www.enterprisedb.com/

--

Salutacions,

____________________________

Jorge Soro