| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Wells Oliver <wells(dot)oliver(at)gmail(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: pg_dump directory format and proper ordering |
| Date: | 2021-06-11 03:54:41 |
| Message-ID: | 1838438.1623383681@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Wells Oliver <wells(dot)oliver(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2021-06-11 06:56:13 | Re: RHEL-8 Kernel Settings |
| Previous Message | Wells Oliver | 2021-06-11 03:37:17 | Re: pg_dump directory format and proper ordering |