On Thu, 20 Nov 2014 11:52:23 -0700 (MST) Marcos Cano <mcano@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general