5 ms·
Well there is no official PostgreSQL solution. It's a bunch of third party solutions with varying levels of quality, documentation, support and use. Every nota
by taligent 14y ago
Well there is no official PostgreSQL solution. It's a bunch of third party solutions with varying levels of quality, documentation, support and use.
Every notable PostgreSQL deployment has had to 'roll their own'.
- joevandyk 14y agoThere is an official pg solution since 9.0. http://www.postgresql.org/docs/9.2/static/warm-standby.html#STREAMING-REPLICATION http://www.postgresql.org/docs/9.2/static/warm-standby.html#...
- taligent 14y agoThat is simply master/slave. Not really suitable for the common scalability issues startups deal with today. Like working in multiple Amazon regions or supporting difference sets of servers.
- joevandyk 14y agoI was responding to you saying that there was no official replication method for postgresql. There has been for about 2.5 years. If you are wanting master-master, look into http://postgres-xc.sourceforge.net http://postgres-xc.sourceforge.net.
- Xylakant 14y agoyou're well aware that the for example the couchbase cross-datacenter-replication has it's own share of problems such as "what happens when the same dataset gets modified in both clusters?". IIRC it just drops the older change and keeps the newer version. That may or may not be a problem to you, but for others that might just be the nail in the coffin. Every datastore out there has different trade-off that are acceptable for different use-cases. And postgres has it's own share of tradeoffs, but it works quite nicely for a lot of use-cases.
- No1 14y agoSlony has been around since at least 2004. It was included in the Postgres source code repository. I always considered that to be a pretty official solution.
- bretthoerner 14y ago> Well there is no official PostgreSQL solution Wrong. September of 2010: http://www.postgresql.org/about/news/1235/ http://www.postgresql.org/about/news/1235/