[postgis-users] Problems installing on Linux

[James David Smith]

On 8 August 2013 15:57, Wilkins, Brian <bwilkins at harris.com> wrote:
> Do you have perl installed? It seems like it is unable to execute the perl script.
>
>
> -----Original Message-----
> From: postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-bounces at lists.osgeo.org] 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 <james.david.smith at gmail.com> wrote:
>> On 6 August 2013 23:32, BladeOfLight16 <bladeoflight16 at gmail.com> wrote:
>>> On Tue, Aug 6, 2013 at 12:53 PM, James David Smith
>>> <james.david.smith at gmail.com> 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
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> 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