Streaming replication in practice.

My slides about PostgreSQL Streaming Replication from PgConf 2016 Russia.



Comments

  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.

    Regards,

    ReplyDelete
    Replies
    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)

      Delete
  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

    ReplyDelete

Post a Comment

Popular Posts