Difference between revisions of "PostgreSQL replication"

From wikieduonline
Jump to navigation Jump to search
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
+
* https://www.postgresql.org/docs/current/runtime-config-replication.html
  
 
  postgres=# [[\du]]
 
  postgres=# [[\du]]
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 ==
* [[START_REPLICATION]]
+
* <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}}
+
* {{PostgreSQL replication}}
 
* {{replication}}
 
* {{replication}}
  
 
[[Category:PostgreSQL]]
 
[[Category:PostgreSQL]]

Latest revision as of 17:53, 8 January 2024

Advertising: