<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><span style="font-family:arial">2014-07-23 11:56 GMT+02:00 Antti J. Lind </span><span dir="ltr" style="font-family:arial"><<a href="mailto:anttij.lind@birdlife.fi" target="_blank">anttij.lind@birdlife.fi</a>></span><span style="font-family:arial">:</span><br>
</div><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">Hi,<br>

<br>
What is your production server's postgres and postgis versions?<br>
<br>
I was successful, when following this, but it's not maybe your case:<br>
<a href="http://www.postgresonline.com/journal/archives/329-An-almost-idiots-guide-to-install-PostgreSQL-9.3,-PostGIS-2.1-and-pgRouting-with-Yum.html" target="_blank">http://www.postgresonline.com/<u></u>journal/archives/329-An-<u></u>almost-idiots-guide-to-<u></u>install-PostgreSQL-9.3,-<u></u>PostGIS-2.1-and-pgRouting-<u></u>with-Yum.html</a><br>

<br>
--<br>
AJL<br>
<br>
Raffaele Morelli kirjoitti 2014-07-23 12:49:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div><div class="h5">
Hi,<br>
<br>
 I upgraded my postgres/postgis installations but loading the dump<br>
from the production server results in tons of errors as these:<br>
<br>
pg_restore: [archiver (db)] could not execute query: ERROR:  could not<br>
access file "$libdir/postgis-2.0": No such file or directory<br>
<br>
 pg_restore: [archiver (db)] could not execute query: ERROR:  could<br>
not access file "$libdir/postgis-1.5": No such file or directory<br>
<br>
I am running debian (testing/jessie) with postgis-2.1.3 and<br>
postgresql-9.3<br>
<br>
 $ pg_config --libdir<br>
/usr/lib/x86_64-linux-gnu<br>
<br>
Any suggestions?<br>
Regards</div></div></blockquote></blockquote><div><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">​Solved with <a href="http://postgis_restore.pl">postgis_restore.pl</a></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">
<br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">/r</div></div></div></div>