is it possible to replicate only 1 or 2 tables and not all the tables? for example if we have 10 tables in node1 server but only 2 tables to be replicated to node2 server using this approach?
Yes. It is possible. You would simply alter the CREATE PUBLICATION command. Example: CREATE PUBLICATION mypublication FOR TABLE users, departments; This example is direct from the core documentation: www.postgresql.org/docs/10/static/sql-createpublication.html
Love your simplistic approach...great videos, keep em coming!
awesome; short, direct, clearly stated. THANK YOU!
Perfect and clear , so exicited for new classes
Loved the simple no-bullshit kinda tutorial! Thanks
such a simple and clear turorial.
Awesomely explained, crisp and clear :+1:
Thanks for making the information available.
Great videos 👍🏼
Very well explained , how can we add a table to an existing replication slot.
Simple but High thinking to do in couple of minutes logical replication....I will try...
Thank you, clearly tutorial.
a tip: watch series at flixzone. Been using them for watching lots of of movies recently.
@Forest Ismael Yup, been using Flixzone} for years myself =)
really a excellent tutorial , any best practice for wal files to be archived,
What I need: Logical replication from Posgres on Windows to Postgres in docker container on Linux
Thanks for sharing this excellent tutorial. ¿Would you please make one about backup plans, and backups having in mind replication?
this replication is synchronous? is possible write some things on node 2 and automatically replica for node 1 or only writing on node 1 for node 2?
Native logical replication, the approach demonstrated here, is not intended to be bi-directional.
is it possible to replicate only 1 or 2 tables and not all the tables? for example if we have 10 tables in node1 server but only 2 tables to be replicated to node2 server using this approach?
Yes. It is possible. You would simply alter the CREATE PUBLICATION command. Example: CREATE PUBLICATION mypublication FOR TABLE users, departments;
This example is direct from the core documentation: www.postgresql.org/docs/10/static/sql-createpublication.html
Your tutorial is very useful!! Do you have other tutorial to talk about Multi-master setup?
Can you create a new schema in node2 (subscriber), and read data from the subscription "employee" table?
Hello, very good tutorial. I see that the replica is active - passive. I would like to know if there is a way for it to be active - active.
Thank you! It's really usefull tutorial. Are you have tutorials about upgrading postgresql from 8.4 to greather?
I've followed everything step by step (pausing and playing the video), and still can't get machine 2 to replicate. I've tried 3 times now.
Were you able to get it to work?
What is the issue you are facing ? Any error message in postgres.log ?
can u know how to do postgresql replication in windows machine
Great video, thank you. However, my replication does not work (no rows are transferred). No idea how to troubleshoot..
I had to grant login to replicator. Why the hell is it required on one system and is not required on another. PG, sigh...
How to create these 2 nodes ?