Streaming replication in practice.

Filters

My slides about PostgreSQL Streaming Replication from PgConf 2016 Russia.

Streaming replication in practice from Алексей Лесовский

ioguix says:
February 8, 2016 at 7:30 pm
Hello Alexey,
On slide 59 about switchover, why are you removing the recovery.conf and restarting the slave ? It seems to me a simple promotion of the slave is cleaner, faster and doesn't require a shutdown of the slave. After creating the proper recovery.conf file on the old master, it will be able to catchup with the new master with no probem, only a timeline change which is not a problem anyway.
Regards,
Reply
Alexey Lesovsky says:
May 6, 2016 at 10:54 am
Timeline change isn't a problem for 9.3 and never releases. In older releases when the timeline is changed, old master can't connect to new master. So removing and restarting is the old and handy habbit))).
Sorry for late answer)
Reply
Bruce Morgan says:
August 14, 2018 at 11:35 am
With IPTV subscription, viewers will be able to watch a lot more television at the same time. Sports fans will be able to keep an eye on six games at once, on the same screen
Reply

Package	Price*
PostgreSQL configuration analysis	from 500 €
Hardware and OS configuration analysis	from 600 €
Slow SQL queries analysis	from 500 €
Comprehensive performance Health Check*	from 3500 €
* For single PostgreSQL installation (1 master + 1 replica)