Search Postgresql Archives

Re: pgdump (9.2.4) not dumping all tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux