pg_restore V12 fails consistently against piped pg_dumps
| От | Mohamed Wael Khobalatte |
|---|---|
| Тема | pg_restore V12 fails consistently against piped pg_dumps |
| Дата | |
| Msg-id | CABZeWdwos=AzBdwuXv2DW_ocMw=bref97voChRhEf80qOk+gdg@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: pg_restore V12 fails consistently against piped pg_dumps
|
| Список | pgsql-general |
Hi all,
When doing a parallel pg_restore (v12) against a dump created through a pipe using an earlier version (11 all the way to 9.6), it fails with the known error of not finding data offsets. I understand the reasons for it (potential inability to seek), which is documented in pg_restore.
What I don't understand is why the same `pg_restore -j` worked in earlier versions (say running pg_restore_v11 against the same dumps). Has anything changed in terms of ordering? I am actually quite curious what led to this finally breaking consistently.
I also timed things, and found that pg_restore_12 against a pg_dump_12 takes about the same time as pg_restore_11 vs pg_dump_11, on the same dataset. I initially did this to see if for some reason pg_restore_v11 was compensating for the lack of the offsets, but this didn't seem to be the case (or perhaps the dump is too small to matter, around 1.5GB).
--
Wael
В списке pgsql-general по дате отправления: