Summary
PostgreSQL roles are a combination of users and groups that are used to implement authentication, authorization, and object ownership within database clusters.
1
To grant the REPLICATION permission to an RDS for PostgreSQL Database user, one must log in to the database as user root and grant the permission.
2
The roles can be managed with attributes such as LOGIN, SUPERUSER, CREATEDB, CREATEROLE, and REPLICATION
3
, and they can be assigned or deleted with permissions such as LOGIN, SUPERUSER, CREATEDB, CREATEROLE, and REPLICATION.
3
Amazon RDS for PostgreSQL is compliant with many industry standards and meets Federal Risk and Authorization Management Program (FedRAMP) security requirements.
4
According to
Summary
This documentation provides an overview of the roles in PostgreSQL, including their privileges, passwords, and run-time configuration settings. It explains how to create a role with the LOGIN attribute, how to create a superuser, how to create databases, how to initiate streaming replication, and how to set default settings. It also provides tips on how to avoid operating as a superuser for tasks that do not really require it.
PostgreSQL: Documentation: 9.4: Role Attributes
postgresql.org
some out of date information, particularly for PostgreSQL 10 and later. Users of this feature should refer to the current PostgreSQL Streaming Replication ...
Streaming Replication - PostgreSQL wiki
postgresql.org
Summary
PostgreSQL roles are a combination of users and groups that are used to implement authentication, authorization, and object ownership within database clusters. Roles are the anchor point within PostgreSQL that determine who authentication and authorization policies apply to, and they are the subject of privilege management rules of all scopes. Roles can be managed with roles with attributes such as LOGIN, SUPERUSER, CREATEDB, CREATEROLE, and REPLICATION, and they can be assigned or deleted with roles with permissions such as LOGIN, SUPERUSER, CREATEDB, CREATEROLE, and REPLICATION.
Managing roles & attributes with PostgreSQL | Prisma
prisma.io
Summary
Amazon RDS for PostgreSQL is a relational database service that supports DB instances running several versions of PostgreSQL. It is compliant with many industry standards and meets Federal Risk and Authorization Management Program (FedRAMP) security requirements. It supports access to databases on a DB instance using any standard SQL client application, and is compliant with many industry standards such as HIPAA-compliant applications and healthcare-related information.
Amazon RDS for PostgreSQL - Amazon Relational Database Service
amazon.com
