Re: Minimum privilege for Backup and replication - Mailing list pgsql-general

From Luca Ferrari
Subject Re: Minimum privilege for Backup and replication
Date
Msg-id CAKoxK+7yLpObBw8ufMHK9FS8uxJHunfKRFcYur-Bg6XdBdLH7w@mail.gmail.com
Whole thread Raw
In response to Minimum privilege for Backup and replication  (Timmy Siu <timmy.siu@aol.com>)
List pgsql-general
On Thu, Oct 10, 2019 at 1:26 PM Timmy Siu <timmy.siu@aol.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



pgsql-general by date:

Previous
From: Alastair McKinley
Date:
Subject: websearch_to_tsquery() and apostrophe inside double quotes
Next
From: "Igal @ Lucee.org"
Date:
Subject: Re: Case Insensitive Comparison with Postgres 12