There *is* an official pg solution since 9.0. http://www.postgresql.org/docs/9.2...

No1 · on Jan 18, 2013

Slony 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.

taligent · on Jan 17, 2013

That 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 · on Jan 18, 2013

I 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.

Xylakant · on Jan 18, 2013

you'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.