On Thu, 20 Nov 2014 11:52:23 -0700 (MST)
Marcos Cano <mc...@stsa.info> wrote:

> i found this in the file... 
> 
> ERROR:  could not access file "$libdir/rtpostgis-2.0": No such file or
> directory
> 
> 
> which acording to the firs link I  found
> <http://gis.stackexchange.com/questions/75520/missing-libraries-when-upgrading-to-postgis-2-1-and-postgresql-9-3-1-using-homeb>
>   

Are you upgrading to a system that also has PostGIS 2.0? Or does it have a 
different
version of PostGIS installed?

Opinions may differ, but I wouldn't call this a bug. If your trying to upgrade 
two
different pieces of software at the same time, you're going to have to know the
internals well enough to work things out. Have you tried upgrading PostgreSQL in
one step and PostGIS in another? Seems like the more practical way to handle 
things.
Probably the best bet is to upgrade PostGIS first, then migrate to the new 
version
of PostgreSQL -- but that depends on your situation.

If that's impractical, you can probably do a pg_dump/restore in 2 stages: first 
do
a pg_dump -s to only dump the schema objects. Manually edit the resultant file 
to
adjust any version-specific PostGIS stuff before loading that into the new 
server.
Then do a pg_dump -a to dump all the data and load that. Whether that works
depends on how much has changed bewteen PostGIS versions -- I haven't worked 
with
PostGIS in almost a year, so I don't know for sure if it will work or not.

-- 
Bill Moran
I need your help to succeed:
http://gamesbybill.com


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to