[postgis-users] can't restore dump in postgis-2.1.3

[Raffaele Morelli]

2014-07-23 11:56 GMT+02:00 Antti J. Lind <anttij.lind at birdlife.fi>:

> Hi,
>
> What is your production server's postgres and postgis versions?
>
> I was successful, when following this, but it's not maybe your case:
> http://www.postgresonline.com/journal/archives/329-An-
> almost-idiots-guide-to-install-PostgreSQL-9.3,-PostGIS-2.1-and-pgRouting-
> with-Yum.html
>
> --
> AJL
>
> Raffaele Morelli kirjoitti 2014-07-23 12:49:
>
>> Hi,
>>
>>  I upgraded my postgres/postgis installations but loading the dump
>> from the production server results in tons of errors as these:
>>
>> pg_restore: [archiver (db)] could not execute query: ERROR:  could not
>> access file "$libdir/postgis-2.0": No such file or directory
>>
>>  pg_restore: [archiver (db)] could not execute query: ERROR:  could
>> not access file "$libdir/postgis-1.5": No such file or directory
>>
>> I am running debian (testing/jessie) with postgis-2.1.3 and
>> postgresql-9.3
>>
>>  $ pg_config --libdir
>> /usr/lib/x86_64-linux-gnu
>>
>> Any suggestions?
>> Regards
>>
>
​Solved with postgis_restore.pl

/r
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140723/2036931e/attachment.html>