Re: Help pg_restore version

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(at)eulerto(dot)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