pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedHelp pg_restore version
6+ messages / 3 participants
[nested] [flat]
* Help pg_restore version
@ 2023-09-30 10:33 Jorge Soro Domenech <jorsodom@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Jorge Soro Domenech @ 2023-09-30 10:33 UTC (permalink / raw)
To: pgsql-bugs
Hi i try restore one backup with this command:
[image: image.png]
But it show this error:
I have this version:
[image: image.png]
And my bak file have this header (i don't see error version here)
[image: image.png]
How can I resolve this problem?
--
Salutacions,
____________________________
Jorge Soro
Attachments:
image.png (image/png, 6.3K) download
view image
image.png (image/png, 1.6K) download
view image
image.png (image/png, 34.1K) download
view image
* Re: Help pg_restore version
@ 2023-10-01 13:29 Euler Taveira <euler@eulerto.com>
parent: Jorge Soro Domenech <jorsodom@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Euler Taveira @ 2023-10-01 13:29 UTC (permalink / raw)
To: Jorge Soro Domenech <jorsodom@gmail.com>; pgsql-bugs
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/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Help pg_restore version
@ 2023-10-01 15:28 Jorge Soro Domenech <jorsodom@gmail.com>
parent: Euler Taveira <euler@eulerto.com>
0 siblings, 1 reply; 6+ messages in thread
From: Jorge Soro Domenech @ 2023-10-01 15:28 UTC (permalink / raw)
To: Euler Taveira <euler@eulerto.com>; +Cc: 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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Help pg_restore version
@ 2023-10-01 15:34 Jorge Soro Domenech <jorsodom@gmail.com>
parent: Jorge Soro Domenech <jorsodom@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Jorge Soro Domenech @ 2023-10-01 15:34 UTC (permalink / raw)
To: Euler Taveira <euler@eulerto.com>; +Cc: pgsql-bugs
I add a more info.
I check .back file and this return "PostreSQL custom database dump -
v1.14-0. Don't understand why the file header have 11.18 database version.
[image: image.png]
El dom, 1 oct 2023 a las 17:28, Jorge Soro Domenech (<jorsodom@gmail.com>)
escribió:
> 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
>
>
--
Salutacions,
____________________________
Jorge Soro
Attachments:
image.png (image/png, 11.3K) download
view image
* Re: Help pg_restore version
@ 2023-10-01 16:18 Tom Lane <tgl@sss.pgh.pa.us>
parent: Jorge Soro Domenech <jorsodom@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Tom Lane @ 2023-10-01 16:18 UTC (permalink / raw)
To: Jorge Soro Domenech <jorsodom@gmail.com>; +Cc: Euler Taveira <euler@eulerto.com>; pgsql-bugs
Jorge Soro Domenech <jorsodom@gmail.com> writes:
> I add a more info.
> I check .back file and this return "PostreSQL custom database dump -
> v1.14-0. Don't understand why the file header have 11.18 database version.
The dump file format version isn't necessarily identical to the
software release version, as we only change the format ID when we
actually change the dump file format. A quick trawl in the source
code says that 1.14 was emitted by pg_dump versions 12.x through 15.x.
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Help pg_restore version
@ 2023-10-01 16:39 Jorge Soro Domenech <jorsodom@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 6+ messages in thread
From: Jorge Soro Domenech @ 2023-10-01 16:39 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Euler Taveira <euler@eulerto.com>; pgsql-bugs
Thank you, i try it use pg_restore with someone this versions 12.x a 15.x
Thank you
Enviado desde mi iPhone
> El 1 oct 2023, a las 18:18, Tom Lane <tgl@sss.pgh.pa.us> escribió:
>
> The dump file format version isn't necessarily identical to the
> software release version, as we only change the format ID when we
> actually change the dump file format. A quick trawl in the source
> code says that 1.14 was emitted by pg_dump versions 12.x through 15.x.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2023-10-01 16:39 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-09-30 10:33 Help pg_restore version Jorge Soro Domenech <jorsodom@gmail.com>
2023-10-01 13:29 ` Euler Taveira <euler@eulerto.com>
2023-10-01 15:28 ` Jorge Soro Domenech <jorsodom@gmail.com>
2023-10-01 15:34 ` Jorge Soro Domenech <jorsodom@gmail.com>
2023-10-01 16:18 ` Tom Lane <tgl@sss.pgh.pa.us>
2023-10-01 16:39 ` Jorge Soro Domenech <jorsodom@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox