Hi Don, On 2/18/18 7:34 PM, Don Seiler wrote: > > Looking to use pgBackRest to take a backup from a hot standby. I'm > reading that pgBackRest still needs to connect to the primary and copy > some files. My questions are: > > 1. What files does it need to copy? Config files? WAL files?
It copies files that are not replicated from the primary so that a primary-style backup is created. Anything that is replicated (which is by far the bulk of the data) is copied from the standby. > 2. How does it connect? SSH? Yes. > 3. Does pgBackRest need to be installed and configured on the primary > as well? Yes. Anyway, it's best to archive from the primary so a replication failure does not affect your archiving. Configuring pgBackRest, SSH, standby, and backup from standby are all covered in the user guide. http://pgbackrest.org/user-guide.html In particular: http://pgbackrest.org/user-guide.html#backup-host http://pgbackrest.org/user-guide.html#replication http://pgbackrest.org/user-guide.html#standby-backup Regards, -- -David da...@pgmasters.net