Re: Minimum privilege for Backup and replication

From: Luca Ferrari <fluca1978(at)gmail(dot)com>
To: Timmy Siu <timmy(dot)siu(at)aol(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Minimum privilege for Backup and replication
Date: 2019-10-10 11:58:35
Message-ID: CAKoxK+7yLpObBw8ufMHK9FS8uxJHunfKRFcYur-Bg6XdBdLH7w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Oct 10, 2019 at 1:26 PM Timmy Siu <timmy(dot)siu(at)aol(dot)com> wrote:
> Now, my question is -
> What is the Minimum Privilege of a pgsql Backup or Replication user?

It is not clear what your question really is. If you are thinking
about a "database user with backup grant", there is no thing like that
in PostgreSQL. If you asking what you need for replication, your user
must have "with replication" flag (create role/alter role).

Hope this helps.
Luca

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Igal @ Lucee.org 2019-10-10 12:41:47 Re: Case Insensitive Comparison with Postgres 12
Previous Message Alastair McKinley 2019-10-10 11:42:20 websearch_to_tsquery() and apostrophe inside double quotes