3 ms·

Hey Jeff, been a postgresql fan for a long time, but clustering is my number one issue. What is coming down the pipe for clustering/replication for PostgreSQL?

jeffdavis 13y ago
Logical replication will be a big deal over the next couple releases. I'm not sure exactly what will be available when, but I know that god foundations are being built now.
- craigching 13y ago
  Jeff, first, thanks for the response and I'm heartened by what you say. If I could suggest, please look at ease of configuring replication in MongoDB. If you make it that easy, even if it's just for the JSON stores, I know that maybe you can't make it easy for relational tables, I will move my product to PostgreSQL in a heartbeat. I have used and promoted PostgreSQL throughout my career, but I'm currently stuck with having to deliver HA in a product for redistribution to customers and Slony can't cut it for our use cases, it's too complicated. I think the key is that we are a vendor and we need to provide a database with our products, so it's not me that's responsible for configuring HA, it's our users. And replication is what I'm concerned about 90% of the time, not necessarily horizontally scaling out (i.e. we're not using sharding in 90% of our cases, we just need HA).
  - jeffdavis 13y ago
    "I'm currently stuck with having to deliver HA in a product" Have you looked at streaming replication in postgres? http://www.postgresql.org/docs/9.3/static/high-availability.html http://www.postgresql.org/docs/9.3/static/high-availability.... http://www.postgresql.org/docs/9.3/static/warm-standby.html#STREAMING-REPLICATION http://www.postgresql.org/docs/9.3/static/warm-standby.html#... I'm not sure what level of expertise your customers are at, so this might not work for you. But it seems like a better fit than slony at least.

3 ms·

Hey Jeff, been a postgresql fan for a long time, but clustering is my number one issue. What is coming down the pipe for clustering/replication for PostgreSQL?

by craigching 13y ago

jeffdavis 13y ago
Logical replication will be a big deal over the next couple releases. I'm not sure exactly what will be available when, but I know that god foundations are being built now.
- craigching 13y ago
  Jeff, first, thanks for the response and I'm heartened by what you say. If I could suggest, please look at ease of configuring replication in MongoDB. If you make it that easy, even if it's just for the JSON stores, I know that maybe you can't make it easy for relational tables, I will move my product to PostgreSQL in a heartbeat. I have used and promoted PostgreSQL throughout my career, but I'm currently stuck with having to deliver HA in a product for redistribution to customers and Slony can't cut it for our use cases, it's too complicated. I think the key is that we are a vendor and we need to provide a database with our products, so it's not me that's responsible for configuring HA, it's our users. And replication is what I'm concerned about 90% of the time, not necessarily horizontally scaling out (i.e. we're not using sharding in 90% of our cases, we just need HA).
  - jeffdavis 13y ago
    "I'm currently stuck with having to deliver HA in a product" Have you looked at streaming replication in postgres? http://www.postgresql.org/docs/9.3/static/high-availability.html http://www.postgresql.org/docs/9.3/static/high-availability.... http://www.postgresql.org/docs/9.3/static/warm-standby.html#STREAMING-REPLICATION http://www.postgresql.org/docs/9.3/static/warm-standby.html#... I'm not sure what level of expertise your customers are at, so this might not work for you. But it seems like a better fit than slony at least.