Difference between revisions of "PostgreSQL replication"
Jump to navigation
Jump to search
| (14 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]] | ||
| + | == See also == | ||
| + | * {{PostgreSQL replication}} | ||
| + | * {{replication}} | ||
| − | + | [[Category:PostgreSQL]] | |
Latest revision as of 17:53, 8 January 2024
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
See also[edit]
Advertising:
