Re: Creating a user for pg_start_backup - Mailing list pgsql-general

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