I'm trying to create a logical replication between 2 Postgres 10 databases in separate clusters. All the process seem to be working, no error and
\dRs+ shows the subscription correctly. The master database is 3TB size approx. How much does it take to start seeing records in the replica database?
The replication process I followed was: Set wal_level to logical. Restart the database.
- Create a user and grant replication privileges.
- Change pg_hba.conf for this replication user.
- Create a publication for all tables.
CREATE PUBLICATION mypub FOR ALL TABLES
Then on the replica:
- Create a database and the tables.
- Create the subscription.
CREATE SUBSCRIPTION mysub CONNECTION 'dbname=testdb host=192.168.1.30 user=rep password=Password port=5432' PUBLICATION mypub;