Thread

1. pgbackrest Help Required

   Inzamam Shafiq <inzamam.shafiq@hotmail.com> — 2022-09-22T06:08:44Z

   Hi Folks,
   
   Hope you are doing well.
   
   I am in process of configuring pgbackrest, I have followed documents and configured backup from backup server. I have a setup of Primary and Hot Standby, when I configured pgbackrest the standby DB got un-synced and now I am unable to recover it, can anyone help or share a good document where we can implement pgbackrest where streaming replication is already in place using traditional pg_basebackup method?
   
   Note: I want to configure pgbackrest and to take backup from standby DB, however streaming replication is already there, where the archive and restore commands are configured using traditional zip method.
   
   Thanks.
   
   Regards,
   
   Inzamam Shafiq
   Sr. DBA
   

2. Re: pgbackrest Help Required

   Stephen Frost <sfrost@snowman.net> — 2022-09-27T15:39:36Z

   Greetings,
   
   * Inzamam Shafiq (inzamam.shafiq@hotmail.com) wrote:
   > I am in process of configuring pgbackrest, I have followed documents and configured backup from backup server. I have a setup of Primary and Hot Standby, when I configured pgbackrest the standby DB got un-synced and now I am unable to recover it, can anyone help or share a good document where we can implement pgbackrest where streaming replication is already in place using traditional pg_basebackup method?
   > 
   > Note: I want to configure pgbackrest and to take backup from standby DB, however streaming replication is already there, where the archive and restore commands are configured using traditional zip method.
   
   Not sure what 'traditional zip method' means here, but if you've copied
   the shell script out of the documentation, that's not a safe
   configuration.
   
   In configuration of pgbackrest, simply configure each of the PG hosts
   and the repo and then set backup-standby=y.  You'll need to make sure
   that the archive_command is set to pgbackrest, of course.  Having an
   existing streaming replication setup is perfectly fine and pgbackrest
   won't interfere with that.  You will want to set your restore command
   to pgbackrest also though, in case streaming fails.
   
   Thanks,
   
   Stephen