On 8 August 2013 15:57, Wilkins, Brian <[email protected]> wrote: > Do you have perl installed? It seems like it is unable to execute the perl > script. > > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of James David Smith > Sent: Thursday, August 08, 2013 10:53 AM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] Problems installing on Linux > > 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 > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Hi Brian, Yes, I think I have Perl installed. If I do: instmodsh l It tells me...: Installed modules are: Perl James _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
