Hacker News new | past | comments | ask | show | jobs | submit login

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




There is an official pg solution since 9.0.

http://www.postgresql.org/docs/9.2/static/warm-standby.html#...


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.


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.


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.


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.


> Well there is no official PostgreSQL solution

Wrong. September of 2010: http://www.postgresql.org/about/news/1235/




Join us for AI Startup School this June 16-17 in San Francisco!

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: