From 6eb9c5a5657d1fe77b55cc261450f3538d35a94d Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:19:15 +0200 Subject: Adding upstream version 13.4. Signed-off-by: Daniel Baumann --- .../sgml/html/logical-replication-quick-setup.html | 31 ++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 doc/src/sgml/html/logical-replication-quick-setup.html (limited to 'doc/src/sgml/html/logical-replication-quick-setup.html') diff --git a/doc/src/sgml/html/logical-replication-quick-setup.html b/doc/src/sgml/html/logical-replication-quick-setup.html new file mode 100644 index 0000000..9036deb --- /dev/null +++ b/doc/src/sgml/html/logical-replication-quick-setup.html @@ -0,0 +1,31 @@ + +30.9. Quick Setup
30.9. Quick Setup
Prev UpChapter 30. Logical ReplicationHome Next

30.9. Quick Setup

+ First set the configuration options in postgresql.conf: +

+wal_level = logical
+

+ The other required settings have default values that are sufficient for a + basic setup. +

+ pg_hba.conf needs to be adjusted to allow replication + (the values here depend on your actual network configuration and user you + want to use for connecting): +

+host     all     repuser     0.0.0.0/0     md5
+

+

+ Then on the publisher database: +

+CREATE PUBLICATION mypub FOR TABLE users, departments;
+

+

+ And on the subscriber database: +

+CREATE SUBSCRIPTION mysub CONNECTION 'dbname=foo host=bar user=repuser' PUBLICATION mypub;
+

+

+ The above will start the replication process, which synchronizes the + initial table contents of the tables users and + departments and then starts replicating + incremental changes to those tables. +

Prev Up Next
30.8. Configuration Settings Home Chapter 31. Just-in-Time Compilation (JIT)
\ No newline at end of file -- cgit v1.2.3