Date: Tue, 29 Apr 2014 22:06:40 -0700
From: Peter Bengtsson <mail@peterbe.com>
To: pgsql-admin@postgresql.org
Message-ID: <63B458542C454ED3A5F58A2323EC9E29@gmail.com>
Subject: Missing loadable libraries when running pg_upgrade 9.2 -> 9.3
 due to json_enhancements
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="536084e0_3804823e_1f4e"
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

--536084e0_3804823e_1f4e
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

In on OSX and I upgraded homebrew which upgraded me to postgres 9.3.  =20
Now postgres won=E2=80=99t start because the old database is no longer co=
mpatible. =20
I found some promising instructions here:
http://blog.55minutes.com/2013/09/postgresql-93-brew-upgrade/

But I get stuck on running this:
pg=5Fupgrade -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=5Fupgrade.log
log here: http://www.peterbe.com/pg=5Fupgrade=5Fserver.log
)

The content of loadable=5Flibraries.txt is this::
Could not load library =22=24libdir/json=5Fenhancements=22
ERROR:  could not access file =22=24libdir/json=5Fenhancements=22: No suc=
h file or directory


Yes, I had json=5Fenhancement installed when I was using postgres 9.2. Bu=
t I don=E2=80=99t need that any more in 9.3 because json=5Fenhancements w=
as a backport for 9.2. =20
The file is still there: /usr/local/Cellar/postgresql/9.2.2/lib/json=5Fen=
hancements.so

So, I can=E2=80=99t upgrade because I don=E2=80=99t have json=5Fenhanceme=
nts installed in 9.3. Which is not possible. =20
And I can=E2=80=99t upgrade by deleting ./lib/json=5Fenhancements.so ./sh=
are/postgresql/extension/json=5Fenhancements--1.0.0.sql and ./share/postg=
resql/extension/json=5Fenhancements.control

How to get out of this pickle=3F

By the way, the database that I think I have it installed on is a databas=
e I can do without. But I can=E2=80=99t simply =60dropdb a=5Fdatabase=5Fw=
ith=5Fjson=5Fenhancements=5Finstalled=60 because dropdb doesn=E2=80=99t w=
ork any more of course. =20


-- =20
Peter Bengtsson
home www.peterbe.com
work www.mozilla.org
fun aroundtheworldgame.com


--536084e0_3804823e_1f4e
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline


                <div>
                    In on OSX and I upgraded homebrew which upgraded me t=
o postgres 9.3.&nbsp;
                </div><div>Now postgres won=E2=80=99t start because the o=
ld database is no longer compatible.&nbsp;</div><div>I found some promisi=
ng instructions here:</div><div><a href=3D=22http://blog.55minutes.com/20=
13/09/postgresql-93-brew-upgrade/=22>http://blog.55minutes.com/2013/09/po=
stgresql-93-brew-upgrade/</a></div><div><br></div><div>But I get stuck on=
 running this:</div><div>pg=5Fupgrade -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</div><div><br></div><div>(</div><di=
v>output here:&nbsp;http://www.peterbe.com/pg=5Fupgrade.log</div><div>log=
 here:&nbsp;http://www.peterbe.com/pg=5Fupgrade=5Fserver.log</div><div>)<=
/div><div><br></div><div>The content of loadable=5Flibraries.txt is this:=
:</div><div><div>Could not load library =22=24libdir/json=5Fenhancements=22=
</div><div>ERROR: &nbsp;could not access file =22=24libdir/json=5Fenhance=
ments=22: No such file or directory</div></div>
                <div><div><br></div><div>Yes, I had json=5Fenhancement in=
stalled when I was using postgres 9.2. But I don=E2=80=99t need that any =
more in 9.3 because json=5Fenhancements was a backport for 9.2.&nbsp;</di=
v><div>The file is still there: /usr/local/Cellar/postgresql/9.2.2/lib/js=
on=5Fenhancements.so</div><div><br></div><div>So, I can=E2=80=99t upgrade=
 because I don=E2=80=99t have json=5Fenhancements installed in 9.3. Which=
 is not possible.&nbsp;</div><div>And I can=E2=80=99t upgrade by deleting=
 ./lib/json=5Fenhancements.so&nbsp;./share/postgresql/extension/json=5Fen=
hancements--1.0.0.sql and&nbsp;./share/postgresql/extension/json=5Fenhanc=
ements.control</div><div><br></div><div>How to get out of this pickle=3F<=
/div><div><br></div><div>By the way, the database that I think I have it =
installed on is a database I can do without. But I can=E2=80=99t simply =60=
dropdb a=5Fdatabase=5Fwith=5Fjson=5Fenhancements=5Finstalled=60 because d=
ropdb doesn=E2=80=99t work any more of course.&nbsp;</div><div><br></div>=
<div><br></div><div><br></div><div>--&nbsp;</div><div>Peter Bengtsson</di=
v><div>home www.peterbe.com</div><div>work www.mozilla.org</div><div>fun =
aroundtheworldgame.com</div><div><br></div></div>
            
--536084e0_3804823e_1f4e--