Re: pg_dump directory format and proper ordering - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dump directory format and proper ordering
Date
Msg-id 1838438.1623383681@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump directory format and proper ordering  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
Wells Oliver <wells.oliver@gmail.com> writes:
> Is there a potential issue when restoring in parallel?

Not supposed to be ...

> I notice for example it fails to re-create some mat views I have in schema
> B as they query from some table in schema A that hasn't been created yet at
> that moment.

You can break it with user-defined functions, because pg_dump can't
really see into the function bodies to understand what they might
reference.  But a matview that doesn't contain anything like that
should Just Work.  If you have a counterexample (against a reasonably
recent PG version), please file a bug report.

            regards, tom lane



pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Re: pg_dump directory format and proper ordering
Next
From: Laurenz Albe
Date:
Subject: Re: RHEL-8 Kernel Settings