3 node cluster for postgres. Requirement: Data sharding+ replication + partitioning
Tech used: PostgreSQL-9.4, PG_Shard and PG_Partman
What I have done till now: I create master table on one node and worker on the other two. I shard my table on these nodes. I partition those shards on the workers.
What is working: I can insert properly from the master node. The data goes to the correct partition of the correct shard.
What is the issue: I cant read from the master node. Although, I can see the data on the shard and also on the partition by connecting to the worker node.
3 node cluster for postgres. Requirement: Data sharding+ replication + partitioning
Tech used: PostgreSQL-9.4, PG_Shard and PG_Partman
What I have done till now: I create master table on one node and worker on the other two. I shard my table on these nodes. I partition those shards on the workers.
What is working: I can insert properly from the master node. The data goes to the correct partition of the correct shard.
What is the issue: I cant read from the master node. Although, I can see the data on the shard and also on the partition by connecting to the worker node.
Any help, please?