Mohamed Wael Khobalatte <mkhobalatte@xxxxxxxxxxx> writes: > 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. Without a concrete example it's hard to say, but maybe the issue is that v12 is more aggressive about parallelizing restores --- see 548e50976. regards, tom lane
