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

From John R Pierce
Subject Re: Creating a user for pg_start_backup
Date
Msg-id 55AE182D.5010600@hogranch.com
Whole thread Raw
In response to Re: Creating a user for pg_start_backup  (Andrew Beverley <andy@andybev.com>)
Responses Re: Creating a user for pg_start_backup  (Andrew Beverley <andy@andybev.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Andrew Beverley
Date:
Subject: Re: Creating a user for pg_start_backup
Next
From: Rafal Pietrak
Date:
Subject: Re: INSERT ... ON CONFLICT DO UPDATE