Re: pgdump (9.2.4) not dumping all tables - Mailing list pgsql-general

From Bill Moran
Subject Re: pgdump (9.2.4) not dumping all tables
Date
Msg-id 20141120141452.a5afce4662b436fa15dd228a@potentialtech.com
Whole thread Raw
In response to Re: pgdump (9.2.4) not dumping all tables  (Marcos Cano <mcano@stsa.info>)
List pgsql-general
On Thu, 20 Nov 2014 11:52:23 -0700 (MST)
Marcos Cano <mcano@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


pgsql-general by date:

Previous
From: Marcos Cano
Date:
Subject: Re: pgdump (9.2.4) not dumping all tables
Next
From: Adrian Klaver
Date:
Subject: Re: better architecture?