Finding database for pg_upgrade missing library - Mailing list pgsql-hackers

From Bruce Momjian
Subject Finding database for pg_upgrade missing library
Date
Msg-id 20180713162815.GA3835@momjian.us
Whole thread Raw
Responses Re: Finding database for pg_upgrade missing library  (Daniel Gustafsson <daniel@yesql.se>)
Re: Finding database for pg_upgrade missing library  (Justin T Pryzby <notifications@telsasoft.com>)
List pgsql-hackers
I received a private pg_upgrade feature request to report the database
name for missing loadable libraries.  Currently we report "could not
load library" and the library file name, e.g. $libdir/pgpool-regclass.

The request is that we report the _database_ name that contained the
loadable library reference.  However, that isn't easy to do because we
gather all loadable library file names, sort them, and remove
duplicates, for reasons of efficiency and so we check libraries in a
predictable alphabetical order.

Is it worth modifying pg_upgrade to report the first or all databases
that contain references to missing loadable libraries?  I don't think
so, but I wanted to ask here.

-- 
  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: Alvaro Herrera
Date:
Subject: Re: Fix some error handling for read() and errno
Next
From: Heikki Linnakangas
Date:
Subject: Re: Generating partitioning tuple conversion maps faster