RE: pg_restore issues with intarray

From: Kevin Brannen <KBrannen(at)efji(dot)com>
To: Jerry Sievers <gsievers19(at)comcast(dot)net>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: RE: pg_restore issues with intarray
Date: 2019-09-06 17:38:06
Message-ID: DM6PR19MB3451E5421593F74A75D47A7AA4BA0@DM6PR19MB3451.namprd19.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>From: Jerry Sievers <gsievers19(at)comcast(dot)net>
>
>
>Try running \dx+ for intarray on one of your deviant systems. You may find the item pg_dump is trying to be explicit about *missing* from the extension member list.
>
>In such a case, see the ALTER EXTENSION ADD... which can be run manually to register whatever is missing.
>
>You will do this on the system that is *origin* for the pg_dump.
>
>This is what we've done.

Hmm, I was really hoping for something on the restore side instead of the
dump side as that makes it harder, but we don't always get what we want. :)

Still, at least was have something to pursue and this is now documented
on the mailing list.

Thanks!
Kevin
This e-mail transmission, and any documents, files or previous e-mail messages attached to it, may contain confidential information. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, distribution, review, copy or use of any of the information contained in or attached to this message is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify us by reply e-mail, and destroy the original transmission and its attachments without reading them or saving them to disk. Thank you.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-09-06 22:39:54 Re: pg_restore issues with intarray
Previous Message Jerry Sievers 2019-09-06 16:58:35 Re: pg_restore issues with intarray