Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Setting Up Logical Replication on PostgreSQL 10
>> wal_level should be >= logical
Limitations of Logical Replication:
>> Schema replication is not supported. >> DDL(s) replication is not supported. >> Replication of sequences is not supported. >> TRUNCATE table is not supported. >> Replication only works for base tables. >> Replication does not work within the databases on the same cluster.
In the test case below, IP 192.168.0.114 is the IP address of my master(publication server) and 192.168.0.115 is for the slave (subscription server).
Creating a publication for logical replication is easy. You can either provide the list of the tables that you need to add to publication, or keyword 'ALL TABLES' could be used to include all the tables. To create the publication, login to the source(master) database.
>> CREATE PUBLICATION pub2 FOR TABLE testtab1, testtab2; OR >> CREATE PUBLICATION pub2 FOR ALL TABLES;
While creating the subscription, you would just need to provide a connection string for the master server and the name of the publication to which you want to connect.