I figured it out. Thanks Selena Deckelmann
http://www.peterbe.com/plog/pg-9.2-to-9.3-json_enhancement
--
Peter Bengtsson
home www.peterbe.com
work www.mozilla.org
fun aroundtheworldgame.com
On Tuesday, April 29, 2014 at 10:19 PM, David G Johnston wrote:
Peter Bengtsson wroteIn 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: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)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 ordirectoryYes, I had json_enhancement installed when I was using postgres 9.2. But Idon’t need that any more in 9.3 because json_enhancements was a backportfor 9.2.The file is still there:/usr/local/Cellar/postgresql/9.2.2/lib/json_enhancements.soSo, I can’t upgrade because I don’t have json_enhancements installed in9.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.controlHow to get out of this pickle?By the way, the database that I think I have it installed on is a databaseI can do without. But I can’t simply `dropdba_database_with_json_enhancements_installed` because dropdb doesn’t workany more of course."This module might make using pg_upgrade difficult or even impossible. Thisuse has not been tested. IF YOU ARE PLANNING TO USE pg_upgrade THEN DO NOTUSE THIS EXTENSION WITHOUT UPGRADE TESTING. If you ignore this warning andit breaks you get to keep all the pieces."Doesn't say anything about how to go about a dump/restore styleupgrade...maybe rebuild the schema in 9.3 manually (more-or-less) then do adata-only dump/restore?Seems you, in theory, should be able to drop the database and extension from9.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-due-to-json-enhancements-tp5801937p5801938.htmlSent from the PostgreSQL - admin mailing list archive at Nabble.com.--Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)To make changes to your subscription:
