[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: Re: [ADMIN] Re: Missing loadable libraries when running pg_upgrade 9.2 -> 9.3 due to json_enhancemen
From: Peter Bengtsson <mail () peterbe ! com>
Date: 2014-04-30 16:30:17
Message-ID: 4850AF4C2BA944B7A50A13877EB7C44C () gmail ! com
[Download RAW message or body]
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 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-due-to-json-enhancements-tp5801937p5801938.html
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com \
> (http://Nabble.com).
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org \
> (mailto:pgsql-admin@postgresql.org)) To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>
[Attachment #3 (text/html)]
<div>
I figured it out. Thanks Selena Deckelmann
</div><div>http://www.peterbe.com/plog/pg-9.2-to-9.3-json_enhancement</div>
<div><div><br></div><div>-- </div><div>Peter Bengtsson</div><div>home \
www.peterbe.com</div><div>work www.mozilla.org</div><div>fun \
aroundtheworldgame.com</div><div><br></div></div>
<p style="color: #A0A0A8;">On Tuesday, April 29, 2014 at 10:19 PM, \
David G Johnston wrote:</p>
<blockquote type="cite" \
style="border-left-style:solid;border-width:1px;margin-left:0px;padding-left:10px;"> \
<span><div><div><div>Peter Bengtsson wrote</div><blockquote type="cite"><div><div>In \
on OSX and I upgraded homebrew which upgraded me to postgres 9.3. </div><div>Now \
postgres won't start because the old database is no longer compatible. </div><div>I \
found some promising instructions here:</div><div><a \
href="http://blog.55minutes.com/2013/09/postgresql-93-brew-upgrade/">http://blog.55minutes.com/2013/09/postgresql-93-brew-upgrade/</a></div><div><br></div><div>But \
I get stuck on running this:</div><div>pg_upgrade -d /usr/local/var/postgres -D \
/usr/local/var/postgres9.3 -b</div><div>/usr/local/Cellar/postgresql/9.2.2/bin/ \
-B</div><div>/usr/local/Cellar/postgresql/9.3.4/bin/ \
-v</div><div><br></div><div>(</div><div>output here: <a \
href="http://www.peterbe.com/pg_upgrade.log">http://www.peterbe.com/pg_upgrade.log</a></div><div>log \
here: <a href="http://www.peterbe.com/pg_upgrade_server.log">http://www.peterbe.com/pg_upgrade_server.log</a></div><div>)</div><div><br></div><div>The \
content of loadable_libraries.txt is this::</div><div>Could not load library \
"$libdir/json_enhancements"</div><div>ERROR: could not access file \
"$libdir/json_enhancements": No such file \
or</div><div>directory</div><div><br></div><div><br></div><div>Yes, I had \
json_enhancement installed when I was using postgres 9.2. But I</div><div>don't need \
that any more in 9.3 because json_enhancements was a backport</div><div>for 9.2. \
</div><div>The file is still \
there:</div><div>/usr/local/Cellar/postgresql/9.2.2/lib/json_enhancements.so</div><div><br></div><div>So, \
I can't upgrade because I don't have json_enhancements installed in</div><div>9.3. \
Which is not possible. </div><div>And I can't upgrade by deleting \
./lib/json_enhancements.so</div><div>./share/postgresql/extension/json_enhancements--1.0.0.sql \
and</div><div>./share/postgresql/extension/json_enhancements.control</div><div><br></div><div>How \
to get out of this pickle?</div><div><br></div><div>By the way, the database that I \
think I have it installed on is a database</div><div>I can do without. But I can't \
simply `dropdb</div><div>a_database_with_json_enhancements_installed` because dropdb \
doesn't work</div><div>any more of course. \
</div></div></blockquote><div><br></div><div><a \
href="http://www.pgxn.org/dist/json_enhancements/doc/json_enhancements.html">http://ww \
w.pgxn.org/dist/json_enhancements/doc/json_enhancements.html</a></div><div><br></div><div>"This \
module might make using pg_upgrade difficult or even impossible. This</div><div>use \
has not been tested. IF YOU ARE PLANNING TO USE pg_upgrade THEN DO NOT</div><div>USE \
THIS EXTENSION WITHOUT UPGRADE TESTING. If you ignore this warning and</div><div>it \
breaks you get to keep all the pieces."</div><div><br></div><div>Doesn't say anything \
about how to go about a dump/restore style</div><div>upgrade...maybe rebuild the \
schema in 9.3 manually (more-or-less) then do a</div><div>data-only \
dump/restore?</div><div><br></div><div>Seems you, in theory, should be able to drop \
the database and extension from</div><div>9.2 then re-do the upgrade without \
them.</div><div><br></div><div>Good Luck...</div><div><br></div><div>David \
J.</div><div><br></div><div><br></div><div><br></div><div><br></div><div>--</div><div>View \
this message in context: <a \
href="http://postgresql.1045698.n5.nabble.com/Missing-loadable-libraries-when-running- \
pg-upgrade-9-2-9-3-due-to-json-enhancements-tp5801937p5801938.html">http://postgresql. \
1045698.n5.nabble.com/Missing-loadable-libraries-when-running-pg-upgrade-9-2-9-3-due-to-json-enhancements-tp5801937p5801938.html</a></div><div>Sent \
from the PostgreSQL - admin mailing list archive at <a \
href="http://Nabble.com">Nabble.com</a>.</div><div><br></div><div><br></div><div>-- \
</div><div>Sent via pgsql-admin mailing list (<a \
href="mailto:pgsql-admin@postgresql.org">pgsql-admin@postgresql.org</a>)</div><div>To \
make changes to your subscription:</div><div><a \
href="http://www.postgresql.org/mailpref/pgsql-admin">http://www.postgresql.org/mailpref/pgsql-admin</a></div></div></div></span>
</blockquote>
<div>
<br>
</div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic