geog_brin_inclusion upgrade issue

[Justin Pryzby]

Automatically fixing the issue is what I was talking about, and what
I've now done.

On Wed, Mar 19, 2025 at 04:32:20PM -0400, lr at pcorp.us wrote:
> I don’t think a regular dump / restore would help nailing down the issue, because the default dump, just stores CREATE EXTENSION command and restore just runs the CREATE EXTENSION from scratch which would automatically fix the issue.
> 
> We’d need the kind of dump that pg_upgrade creates.  I never looked to see what command it does to backup the extension contents of the db.
> 
> From: Paul Ramsey <pramsey at cleverelephant.ca> 
> Sent: Wednesday, March 19, 2025 3:19 PM
> To: Justin Pryzby <pryzby at telsasoft.com>
> Cc: Regina Obe <lr at pcorp.us>; PostGIS Development Discussion <postgis-devel at lists.osgeo.org>
> Subject: Re: geog_brin_inclusion upgrade issue
> 
> Yeah, if the data are small enough to be tractable for a dump/restore, that’s clearly the way to go.
> 
> On Mar 19, 2025, at 12:10 PM, Justin Pryzby <pryzby at telsasoft.com <mailto:pryzby at telsasoft.com> > wrote:
> 
> There was definitely an upgrade issue, but it's been a few years, and if
> nobody else has complaind, then it seems like the thing to do might be
> to drop postgis and reinstall it.