[postgis-users] Correct dump and restore

Stefan Schwarzer stefan.schwarzer at grid.unep.ch
Sun Nov 12 22:59:14 PST 2006

Thanks for the suggestions.

The pg_dump works.

For the _restore I had to download the latest source package. But  
because I don't do any compilations/makes I just accessed the files  
in the download directory.

So if I run the below mentioned postgis_restore.pl command I get the  
following error:

dyld: Library not loaded: /usr/local/pgsql/lib/libpq.3.dylib
   Referenced from: /usr/local/bin/pg_restore
   Reason: image not found
dyld: Library not loaded: /usr/local/pgsql/lib/libpq.3.dylib
   Referenced from: /usr/local/bin/pg_restore
   Reason: image not found
pg_restore call failed

There is a copy of that file on my computer under /Library/PHP4/lib/ 

I tried to do a link: libpq.3.dylib -> /Library/PHP4/lib/libpq.3.dylib

But still it doesn't work.

However there is a file libpq.4.1.dylib in /usr/local/pgsql/lib

Gush, why are things always so complicated?

Thanks for any help!


> * Stefan Schwarzer <stefan.schwarzer at grid.unep.ch> [061110 15:55]:
>> Under "Hard upgrade" I don't find anything. I guess you mean this
>> section (page 5)? Seems still rather complicated....
> I think strk was talking about the online Doku:
> http://postgis.refractions.net/docs/ch02.html#upgrading
> Essentially it is
> $ pg_dump -Fc olddb olddb.dump
> and
> $ sh utils/postgis_restore.pl lwpostgis.sql newdb olddb.dump >  
> restore.log
> The rest are checks and cleanups if migration from older postgresql
> versions -  which isn't the case in your situation.
> Regards,
>         Frank
> -- 
> Frank Koormann                              
> <frank.koormann at intevation.de>
>  Professional Service around Free Software       (http:// 
> intevation.net/)
>  FreeGIS Project                                 (http://freegis.org/)
>  PostGIS Support     (http://intevation.de/services/gis/ 
> postgis.en.html)
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list