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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general