I've noticed that psql doesn't like input of shell script files (it wants
.sql like files).
So just plain running these commands from the terminal, (without the [pgsql
bin]/psql -f) works fine, and I am now getting data.
On Mon, Oct 26, 2009 at 11:57 AM, Peter Dietz <dietz.72@...> wrote:
> I'm having an issue with getting the final step of the Statistics Addon
> from UMinho for Dspace 1.5.2 working. That is crontab to aggregate the
> I have my crontab set to run (for testing, every minute) the stats
> aggregation command. And I'm not seeing any results. Wondering what the
> issue was, I've tried to just run that same command at a terminal, and it
> gives me errors as postgres tries to parse the file.
> bash-3.2$ psql -f /dspace/bin/stats-aggregate
> psql:/dspace/bin/stats-aggregate:51: ERROR: syntax error at or near "#!/"
> at character 1
> psql:/dspace/bin/stats-aggregate:51: LINE 1: #!/bin/sh
> psql:/dspace/bin/stats-aggregate:51: ^
> bash-3.2$ psql -f /dspace/bin/stats-aggregate -c -a
> ERROR: syntax error at or near "-" at character 1
> LINE 1: -a
> Any help would be most appreciated.
> Peter Dietz
> OSU Libraries - Systems Developer/Engineer
> 614.441.8182 - dietz.72@...
OSU Libraries - Systems Developer/Engineer
614.441.8182 - dietz.72@...