From: David G Johnston <david.g.johnston@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Missing loadable libraries when running pg_upgrade 9.2 -> 9.3 due to json_enhancements
Date: Tue, 29 Apr 2014 22:19:59 -0700 (PDT)
Message-ID: <1398835199020-5801938.post@n5.nabble.com> (raw)
In-Reply-To: <63B458542C454ED3A5F58A2323EC9E29@gmail.com>
References: <63B458542C454ED3A5F58A2323EC9E29@gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Peter Bengtsson wrote
> In on OSX and I upgraded homebrew which upgraded me to postgres 9.3.
> Now postgres won’t start because the old database is no longer compatible.
> I found some promising instructions here:
> http://blog.55minutes.com/2013/09/postgresql-93-brew-upgrade/
>
> But I get stuck on running this:
> pg_upgrade -d /usr/local/var/postgres -D /usr/local/var/postgres9.3 -b
> /usr/local/Cellar/postgresql/9.2.2/bin/ -B
> /usr/local/Cellar/postgresql/9.3.4/bin/ -v
>
> (
> output here: http://www.peterbe.com/pg_upgrade.log
> log here: http://www.peterbe.com/pg_upgrade_server.log
> )
>
> The content of loadable_libraries.txt is this::
> Could not load library "$libdir/json_enhancements"
> ERROR: could not access file "$libdir/json_enhancements": No such file or
> directory
>
>
> Yes, I had json_enhancement installed when I was using postgres 9.2. But I
> don’t need that any more in 9.3 because json_enhancements was a backport
> for 9.2.
> The file is still there:
> /usr/local/Cellar/postgresql/9.2.2/lib/json_enhancements.so
>
> So, I can’t upgrade because I don’t have json_enhancements installed in
> 9.3. Which is not possible.
> And I can’t upgrade by deleting ./lib/json_enhancements.so
> ./share/postgresql/extension/json_enhancements--1.0.0.sql and
> ./share/postgresql/extension/json_enhancements.control
>
> How to get out of this pickle?
>
> By the way, the database that I think I have it installed on is a database
> I can do without. But I can’t simply `dropdb
> a_database_with_json_enhancements_installed` because dropdb doesn’t work
> any more of course.
http://www.pgxn.org/dist/json_enhancements/doc/json_enhancements.html
"This module might make using pg_upgrade difficult or even impossible. This
use has not been tested. IF YOU ARE PLANNING TO USE pg_upgrade THEN DO NOT
USE THIS EXTENSION WITHOUT UPGRADE TESTING. If you ignore this warning and
it breaks you get to keep all the pieces."
Doesn't say anything about how to go about a dump/restore style
upgrade...maybe rebuild the schema in 9.3 manually (more-or-less) then do a
data-only dump/restore?
Seems you, in theory, should be able to drop the database and extension from
9.2 then re-do the upgrade without them.
Good Luck...
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Missing-loadable-libraries-when-running-pg-upgrade-9-2-9-3-d...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: david.g.johnston@gmail.com
Subject: Re: Missing loadable libraries when running pg_upgrade 9.2 -> 9.3 due to json_enhancements
In-Reply-To: <1398835199020-5801938.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox