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