Date: Thu, 15 Nov 2018 20:18:02 +0200 (EET)
From: pgsql-admin@kolttonen.fi
To: pgsql-admin@postgresql.org
Subject: The current shape of PG master-slave replication
Message-ID: <alpine.LFD.2.21.1811152002490.16940@localhost>
User-Agent: Alpine 2.21 (LFD 202 2017-01-01)
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Precedence: bulk


Hello!

I am a happy PostgreSQL user, but I have never tried PG replication at all. 

Based on my vague recollections concerning the past, MySQL used to have 
the advantage of having a pretty stable and working master-slave 
replication when PG did not have such a thing. But PG has been more 
SQL-compliant, has had foreign keys forever, and in general, I guess PG 
has had a more advanced feature set available.

I have followed the progress of PostgreSQL regarding replication just 
occasionally, but not very actively. Master-slave replication is now 
officially supported in the newest releases, maybe has been for a long 
time, I am not sure.

In any case it is not my intention to spark a heated discussion about the 
merits of MySQL/MariaDB vs PostgreSQL. All I am asking is maybe hearing 
some observations of PG admins out there.

To be concrete, if I use PG 10.x master-slave replication in production, 
is it very reliable when set up properly? Any practical experiences? Well, 
I suppose it *must* be reliable, but I am interested in hearing of 
possible problems, too.

Thanks for the information.

Best regards,
Unto Sten