Difference between revisions of "PostgreSQL replication"
Jump to navigation
Jump to search
| (15 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | * https://www.postgresql.org/docs/current/runtime-config-replication.html | ||
| + | postgres=# [[\du]] | ||
| + | List of roles | ||
| + | Role name | Attributes | [[Member of]] | ||
| + | ----------------+------------------------------------------------------------+----------- | ||
| + | YOUR_USER | [[Create DB]] | {} | ||
| + | [[postgres]] | [[Superuser]], [[Create role]], [[Create DB]], [[PostgreSQL replication|Replication]], [[Bypass RLS]] | {} | ||
| − | + | == Related == | |
| + | * <code>[[START_REPLICATION]] SLOT</code> | ||
| + | * [[Amazon RDS Read Replicas]] | ||
| + | * <code>select * from [[pg_replication_slots]];</code> | ||
| + | * <code>[[\du+]]</code> | ||
| + | * [[CREATE SUBSCRIPTION]] | ||
| + | * [[CREATE ROLE]] | ||
| + | * [[Terraform resource: postgresql role]] | ||
== See also == | == See also == | ||
| + | * {{PostgreSQL replication}} | ||
* {{replication}} | * {{replication}} | ||
[[Category:PostgreSQL]] | [[Category:PostgreSQL]] | ||
Latest revision as of 17:06, 29 May 2025
postgres=# \du List of roles Role name | Attributes | Member of ----------------+------------------------------------------------------------+----------- YOUR_USER | Create DB | {} postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
Related[edit]
START_REPLICATION SLOT- Amazon RDS Read Replicas
select * from pg_replication_slots;\du+- CREATE SUBSCRIPTION
- CREATE ROLE
- Terraform resource: postgresql role
See also[edit]
Advertising:
