On 7/21/2015 1:51 AM, Andrew Beverley wrote:
> Thanks John. The backup script is running as root, so presumably I'd have to use
> sudo? Or should I run a separate cron job as postgres to do the above, and run the
> backup script separately?
those are both possibilities. I'd either use su (not sudo) from root,
or I'd cron it from the postgres DBA account, depending.
--
john r pierce, recycling bits in santa cruz