Creating a user for pg_start_backup - Mailing list pgsql-general

From Andrew Beverley
Subject Creating a user for pg_start_backup
Date
Msg-id 1437464845.20338.11.camel@andybev.com
Whole thread Raw
Responses Re: Creating a user for pg_start_backup  (Michael Paquier <michael.paquier@gmail.com>)
Re: Creating a user for pg_start_backup  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-general
Dear all,

I'm setting up hot backups on my database server. As such, I'd like to set up a
Postgres user that has access to only pg_start_backup and pg_stop_backup.

I'm unable to work out how to do this with the various GRANT options. Can someone
point me in the right direction please? Or is there a better way to achieve this,
rather than having a dedicated user?

Thanks,

Andy



pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: INSERT ... ON CONFLICT DO UPDATE
Next
From: Michael Paquier
Date:
Subject: Re: Creating a user for pg_start_backup