Re:PostgreSQL 10 Beta 1 Released
by jeltz on Tuesday June 27, 2017 @07:41AM
(#14644413)
As a heavy PostgreSQL user, who by now may be blind to some issues, I have to ask what makes PostgreSQL replication hard to configure. As far as I recall setting up replication in MySQL and PostgreSQL is very similar.
[ Parent
| on HN ]
PostgreSQL has gotten massively easier in terms of replication during the 9.x series. It used to be the case that you cobbled something together yourself or had to rely on complex third party solutions that might do things like install a ton of triggers. Now it's about as simple as MySQL. But it took many years to catch up, so that definitively used to be a pain point.
The big remaining piece now is "sane" multi-master replication.
Oh yeah, I too have written my own shell scripts for log shipping and failover some time 6-8 years ago when I was still using PostgreSQL 8.4. But talking about this in a comparison makes about as much sense as bringing up MyISAM related issues.