On Tue, 2015-07-21 at 03:00 -0700, John R Pierce wrote:
> 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.
Sorry to be dragging this off-topic, but what's the reason for using su instead of
sudo?
Thanks,
Andy