Re: [HACKERS] pg_upgrade and missing loadable libraries - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] pg_upgrade and missing loadable libraries
Date
Msg-id 20180728163506.GA22661@momjian.us
Whole thread Raw
In response to [HACKERS] pg_upgrade and missing loadable libraries  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On Sun, Jun  4, 2017 at 01:06:25PM -0400, Bruce Momjian wrote:
> I have seen a few reports where people are getting this pg_upgrade
> error:
> 
>     Your installation references loadable libraries that are missing
>     from the new installation.  You can add these libraries to the
>     new installation, or remove the functions using them from the
>     old installation.  A list of problem libraries is in the file:
>     
>         ./loadable_libraries.txt
>     
> and the file contains:
> 
>     could not load library "$libdir/pgpool-regclass":
>     ERROR:  could not access file "$libdir/pgpool-regclass": No such file or directory
> 
> The problem is that there is no indication of which database to look in. 
> Should we adjust the output to suggest the first database that has it,
> or update the instructions to mention they have to look in all
> databases, and give them some instructions on finding the problem?

I have just implemented a fix for this 2017 report by reporting all
databases.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Removing useless \. at the end of copy in pgbench
Next
From: Bruce Momjian
Date:
Subject: Re: Finding database for pg_upgrade missing library