Re: pgbackrest Help Required

Greetings,

* Inzamam Shafiq (inzamam(dot)shafiq(at)hotmail(dot)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