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: [email protected] [mailto:[email protected]] 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 <[email protected]> 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: [email protected] > [mailto:[email protected]] 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 <[email protected]> wrote: >> On 8 August 2013 15:57, Wilkins, Brian <[email protected]> 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 > [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 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 [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
