Subject: Re: NEEDING HELP: dropping none-existing extension
To: pgsql-admin@lists.postgresql.org
References: <4A197984-1E5A-410C-ACDF-83E18A4734E5@Chaos1.DE>
From: Ron <ronljohnsonjr@gmail.com>
Message-ID: <7853427a-c037-2bc1-f0b5-b54e8f1cccc1@gmail.com>
Date: Sat, 4 Apr 2020 11:24:02 -0500
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.4.1
MIME-Version: 1.0
In-Reply-To: <4A197984-1E5A-410C-ACDF-83E18A4734E5@Chaos1.DE>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: en-US
Precedence: bulk

On 4/4/20 10:48 AM, Axel Rau wrote:
> Hi all
>
> during upgrade from 11 to 12, pg_upgrade errors out:
> - - -
> could not load library "$libdir/pg_repack": ERROR:  could not access file "$libdir/pg_repack": No such file or directory
> Database: development
> Database: operations
> Database: pki_op
> - - -
> I find no extension pg_repack, only views with that name in those DBs.
> While trying to drop them, I get:
> - - -
> ERROR: cannot drop schema repack because extension pg_repack requires it HINT: You can drop extension pg_repack instead.
> - - -
>
> How can I get rid of those views?

Are you trying to drop the extension pg_repack *before* doing the upgrade?

-- 
Angular momentum makes the world go 'round.