Got it finally. I had the su to postgres that was needed when run from the
command line but is not needed since the script is run as bareos so just this
works. Arrghhh!!
emptyVols=$(psql -d bareos -t -c "select m.VolumeName from Media m where
m.VolStatus not in ('Append','Purged') and not exists (Select 1 from JobMedia
jm where jm.MediaId=m.MediaID);")
--
You received this message because you are subscribed to the Google Groups
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
For more options, visit https://groups.google.com/d/optout.
