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

Post a Comment

Popular Posts