Difference between revisions of "PostgreSQL replication"
Jump to navigation
Jump to search
| (5 intermediate revisions by the same user not shown) | |||
| Line 6: | Line 6: | ||
----------------+------------------------------------------------------------+----------- | ----------------+------------------------------------------------------------+----------- | ||
YOUR_USER | [[Create DB]] | {} | YOUR_USER | [[Create DB]] | {} | ||
| − | [[postgres]] | Superuser, Create role, Create DB, [[PostgreSQL replication|Replication]], [[Bypass RLS]] | {} | + | [[postgres]] | [[Superuser]], [[Create role]], [[Create DB]], [[PostgreSQL replication|Replication]], [[Bypass RLS]] | {} |
== Related == | == Related == | ||
* <code>[[START_REPLICATION]] SLOT</code> | * <code>[[START_REPLICATION]] SLOT</code> | ||
* [[Amazon RDS Read Replicas]] | * [[Amazon RDS Read Replicas]] | ||
| − | * <code>[[pg_replication_slots]]</code> | + | * <code>select * from [[pg_replication_slots]];</code> |
| + | * <code>[[\du+]]</code> | ||
| + | * [[CREATE SUBSCRIPTION]] | ||
== See also == | == See also == | ||
* {{PostgreSQL replication}} | * {{PostgreSQL replication}} | ||
* {{replication}} | * {{replication}} | ||
| − | |||
[[Category:PostgreSQL]] | [[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:
