Streaming replication in practice.

My slides about PostgreSQL Streaming Replication from PgConf 2016 Russia.


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


    1. 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)

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


Post a Comment

You might also be interested in

Deep dive into postgres stats: pg_stat_replication

Deep dive into Postgres stats: pg_stat_progress_vacuum

pg_wal is too big… what's going on?