On Fri, Sep 28, 2012 at 07:52:59PM -0400, I wrote:
> I've just upgraded a test lab to the newly committed pgpool-II 3.2.0 and
> upgraded postgreSQL databases from 9.1.5 to 9.2.1 with it.
>
> Installing pgpool_regclass was working prior to this upgrade. Now, the
> symptom I see is this (lines split for readability):
>
> $ psql -h localhost -p 5433 -U postgres -f pgpool-regclass.sql template1
> Password for user postgres:
> psql:pgpool-regclass.sql:4: ERROR: could not load library
> "/usr/local/lib/postgresql/pgpool-regclass.so": dlopen
> (/usr/local/lib/postgresql/pgpool-regclass.so) failed: Cannot load specified
> object
This problem was self-inflicted; I started to build pgpool-II with
postgresql-server 9.1.5 installed; it aborted part way due to a libpq libspec
issue, then I restarted the build with postgresql-server 9.2.0 installed,
without taking the time to make clean before rebuilding the port.
I wish to thank Pierre-Emannuel Andre' (pea@) for his diagnostic efforts and
his tests with many different combinations of PostgreSQL versions and pgpool
versions in a vain attempt to recreate my problem. I wish to apologize also,
as I wasted his valuable time with this PEBKAC, time he will never get back.
For lack of a clue
We waste developers' time.
Tread carefully now.
