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
awesome; short, direct, clearly stated. THANK YOU!
Love your simplistic approach...great videos, keep em coming!
Loved the simple no-bullshit kinda tutorial! Thanks
such a simple and clear turorial.
Perfect and clear , so exicited for new classes
Awesomely explained, crisp and clear :+1:
Thanks for making the information available.
What I need: Logical replication from Posgres on Windows to Postgres in docker container on Linux
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 =)
Simple but High thinking to do in couple of minutes logical replication....I will try...
Great videos 👍🏼
Very well explained , how can we add a table to an existing replication slot.
Thanks for sharing this excellent tutorial. ¿Would you please make one about backup plans, and backups having in mind replication?
really a excellent tutorial , any best practice for wal files to be archived,
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 ?
Your tutorial is very useful!! Do you have other tutorial to talk about Multi-master setup?
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.
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.
Thank you! It's really usefull tutorial. Are you have tutorials about upgrading postgresql from 8.4 to greather?
Can you create a new schema in node2 (subscriber), and read data from the subscription "employee" table?
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...
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
can u know how to do postgresql replication in windows machine
How to create these 2 nodes ?