|From:||Peter Bengtsson <mail(at)peterbe(dot)com>|
|Subject:||Missing loadable libraries when running pg_upgrade 9.2 -> 9.3 due to json_enhancements|
|Views:||Raw Message | Whole Thread | Download mbox|
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:
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
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.
|Next Message||David G Johnston||2014-04-30 05:19:59||Re: Missing loadable libraries when running pg_upgrade 9.2 -> 9.3 due to json_enhancements|
|Previous Message||Steve Crawford||2014-04-29 22:38:50||Re: Slow backups over VPN|