Melissa, Sounds like the database user for the cron script doesn't have the proper permissions for the record_sorter table. You'll need to GRANT the proper perms to that user (see http://www.postgresql.org/docs/current/static/sql-grant.html - making sure to select the correct PostgreSQL version at the top of the page).
I hope that helps get you on the right path! Chris ----- Original Message ----- > From: "Melissa Ceraso" <[email protected]> > To: "Evergreen Discussion Group" <[email protected]> > Sent: Wednesday, March 16, 2016 12:20:29 PM > Subject: [OPEN-ILS-GENERAL] Wowbrary Script Error > > Hello, > > We altered a Wowbrary SQL script to fix a few errors that were occurring > for some of our Wowbrary subscribers. The amended script runs fine on our > database server. Yet, since it has been applied to our utility server to > run as a cron job, we are consistently receiving the following error > message: > > 53: ERROR: permission denied for relation record_sorter > > At this point, we cannot figure out why the script runs fine on the > database, but fails during the cron job. Any thoughts, ideas or even a lead > as to where I should start investigating further would be greatly > appreciated! Also, if further information is needed, I can certainly > provide more. > > All the best, > > Melissa > > Melissa Ceraso > Evergreen Systems Manager > Bibliomation, Inc. > 24 Wooster Ave. > Waterbury, CT 06708 > 203-577-4070 ext. 116 > -- Chris Sharp PINES System Administrator Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, Georgia 30345 (404) 235-7147 [email protected] http://pines.georgialibraries.org/
