suppose I created two node with node1 =port 9701 and node2 = post 9102 on a single linux system. Now how should i login into that node 1 or node 2 inorder to create db inside it
This is how we connect on a single host ( i hope the node name is same ). psql -h node1 -p 9701 psql -h node2 -p 9702 This concept is covered under PostgreSQL cluster
Very informative and detailed video,
Glad it was helpful!
This is super great tutorial, thanks for sharing sir
Glad it was helpful!
Is logical replication supported in PostgreSQL 9.x ?
Very informative
Glad it was helpful!
great!!!
Thank you
Very informative. Can we implement bi-directional replication with Logical replication? If not possible could you suggest best way to achieve it?
It seems to be possible, The challenging part may be when you try to use it on Premises and specially handling conflicts.
suppose I created two node with node1 =port 9701 and node2 = post 9102 on a single linux system. Now how should i login into that node 1 or node 2 inorder to create db inside it
This is how we connect on a single host ( i hope the node name is same ).
psql -h node1 -p 9701
psql -h node2 -p 9702
This concept is covered under PostgreSQL cluster
how conflicts can happen ? write or read conflicts for Same table and different subscribers?
Will upload a demo for covering this topic.
Can u please give step by step procedure to setup logical replication in PostgreSQL on WINDOWS SERVER
Yes sure