[postgis-users] Problems installing on Linux

[Wilkins, Brian]

postgis.sql.lst is the manifest file used to read in the sql functions, tables, etc. It is the original SQL plus .lst concatenated onto the filename.

Make sure /usr/pgsql-9.0/share/contrib/postgis-2.0/ has permissions set to 755. For example, chmod 755 /usr/pgsql-9.0/share/contrib/postgis-2.0/

Or you can copy the script to like /tmp along with your sql and make sure your user can write to /tmp. 

-----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 11:31 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Problems installing on Linux

On 8 August 2013 16:13, Wilkins, Brian <bwilkins at harris.com> wrote:
> See here: 
> http://stackoverflow.com/questions/2517106/why-do-i-get-use-command-no
> t-found-when-i-run-my-perl-script
>
> Could be your shell.
>
> -----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 11:04 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Problems installing on Linux
>
> On 8 August 2013 16:02, James David Smith <james.david.smith at gmail.com> wrote:
>> On 8 August 2013 15:57, Wilkins, Brian <bwilkins at harris.com> wrote:
> [snip]
>> James
>
> Also if I run "  perl -v  "   then I get:
>
>  "  This is perl, v5.8.8 built for x86_64-linux-thread-multi  "
> _______________________________________________
> 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


Great stuff Brian. I've no idea how you knew that. But putting 'perl'
at the start seems to get it started. Though another problem unfortunately!

------------WHEN I RUN THE SCRIPT-------- perl /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_05082013.sql > restore.log

---------THIS IS WHAT I GET ---------------- Converting /usr/pgsql-9.0/share/contrib/postgis-2.0/postgis.sql to ASCII on stdout...
  Reading list of functions to ignore...
  Writing manifest of things to read from dump file...
:    Cannot open manifest file
'/usr/pgsql-9.0/share/contrib/postgis-2.0/postgis.sql.lst'
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users