Re: [HACKERS] pg_upgrade and missing loadable libraries

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] pg_upgrade and missing loadable libraries
Date: 2018-07-28 16:35:06
Message-ID: 20180728163506.GA22661@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)momjian(dot)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 +

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2018-07-28 16:39:59 Re: Finding database for pg_upgrade missing library
Previous Message Tom Lane 2018-07-28 15:10:54 Re: Removing useless \. at the end of copy in pgbench