Creating a user for pg_start_backup

Поиск
Список
Период
Сортировка
От Andrew Beverley
Тема Creating a user for pg_start_backup
Дата
Msg-id 1437464845.20338.11.camel@andybev.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Francisco Olarte
Дата:
Сообщение: Re: INSERT ... ON CONFLICT DO UPDATE
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Creating a user for pg_start_backup