PostgreSQL Replication Failback with pg_rewind

Поділитися
Вставка

КОМЕНТАРІ • 10

  • @pierpaolobruno4056
    @pierpaolobruno4056 Рік тому

    thanks, great video

  • @1487atul
    @1487atul Рік тому +1

    I think there is no need to define restore_command in recovery.conf file if you are already creating a replication slot. please correct me if I am wrong as far as I know restore_command is needed when you are archiving xlog file to archive location but if you have replication slot then there is no need of restore_command . please correct me If I am wrong ?

  • @LuisDiaz-uu7xg
    @LuisDiaz-uu7xg 2 роки тому

    Hello
    many thanks for all this good videos. I wonder if you have the failover and failback with postgres version 12 or 13 ?

  • @DeathKing61801
    @DeathKing61801 5 місяців тому

    Hello, please do postgres 14

  • @santhoshvr
    @santhoshvr 4 роки тому +1

    What is difference between pgbasebackup and pgrewind.. can you explain please

    • @lonewolf796
      @lonewolf796 3 роки тому +2

      pgbasebackup takes backup of whole cluster , whereas pgrewind synchronises timeline of main and replica by deleting records if inserted on main after promoting replica

    • @santhoshvr
      @santhoshvr 3 роки тому +1

      @@lonewolf796 Tanq bro 👍

    • @fardeenmirza8073
      @fardeenmirza8073 Рік тому

      If we have updates on new master. Does pg_rewind sync the data from new master to the new replica(old master)?

    • @sumitmamgai4581
      @sumitmamgai4581 9 місяців тому

      @@fardeenmirza8073 Yess