On 8 August 2013 09:43, James David Smith <[email protected]> wrote: > On 6 August 2013 23:32, BladeOfLight16 <[email protected]> wrote: >> On Tue, Aug 6, 2013 at 12:53 PM, James David Smith >> <[email protected]> wrote: >>> >>> However it says that Topology and Raster support are not present. So I >>> thought that I could now run the following commands to install those >>> too: >>> >>> <snip> >>> >>> >>> psql:/usr/pgsql-9.0/share/contrib/postgis-2.0/rtpostgis.sql:48: ERROR: >>> could not load library "/usr/pgsql-9.0/lib/rtpostgis-2.0.so": >>> libgeos-3.2.0.so: cannot open shared object file: No such file or >>> directory >>> >>> Any idea why there is still mention of libgeos-3.2.0 ? I thought I'd >>> sorted that out now? >> >> >> Could rtpostgis-2.0.so be a pg-routing binary? I noticed two of your copies >> of GEOS are in subdirectories of /depot/shared/pgrouting/. Maybe the routing >> binary is still linked to the old GEOS. >> >> As for raster, did you install GDAL? I'm pretty sure that GDAL is required >> for raster support. >> >> Honestly, you have a lot of different pieces and versions installed, and >> since you installed a bunch of them manually, cleaning them out does not >> seem practical. Have you considered just installing on a clean machine >> that's never had PostgreSQL? Or maybe even backing up your data and then >> wiping this machine (assuming there even is data to preserve)? Even if it >> costs a little bit to get a clean machine, I bet it's less than the cost of >> your time (assuming you're on the job). >> >> _______________________________________________ > > Hi all, > > Just reporting back. Have made progress again. We had to clean and > then re-make and install GDAL. If I'm honest I'm not quite sure why, > but once we had done this everything seemed to work ok. :-) > > Thanks > > James
Hi there, Not quite done I'm afraid. Sorry and thanks for your continued help. I've now got a database in my cluster called 'james_traffic_restored' which is a postgis2 database with topology and raster support enabled. Great. Before I started all this I dumped my old database using pg_dump. pg_dump mydb > db.sql I saved it as a SQL file and also as a dump file. /home/james/james_traffic_08082013.dump /home/james/james_traffic_08082013.sql I now want to put this data back into my newly database called 'james_traffic_restored'. So I do this: pg_restore -d james_traffic_restored james_traffic_08082013.dump However I get lots of errors. I've not bothered providing them, as I think that this is wrong anyway. I think I need to do something like this instead: sh /usr/pgsql-9.0/share/contrib/postgis-2.0/postgis_restore.pl /usr/pgsql-9.0/share/contrib/postgis-2.0/postgis.sql james_traffic_restored james_traffic_08082013.dump > restore.log But I get the following errors: /usr/pgsql-9.0/share/contrib/postgis-2.0/postgis_restore.pl: line 31: use: command not found /usr/pgsql-9.0/share/contrib/postgis-2.0/postgis_restore.pl: line 32: use: command not found /usr/pgsql-9.0/share/contrib/postgis-2.0/postgis_restore.pl: line 34: my: command not found /usr/pgsql-9.0/share/contrib/postgis-2.0/postgis_restore.pl: line 36: my: command not found /usr/pgsql-9.0/share/contrib/postgis-2.0/postgis_restore.pl: line 37: syntax error near unexpected token `newline' /usr/pgsql-9.0/share/contrib/postgis-2.0/postgis_restore.pl: line 37: `Usage: $me [-v] <dumpfile>' I've had a look at the postgis_restore file around these lines, but I'm not sure what the problem is. Thanks James _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
