Search Postgresql Archives

Re: pgBackRest backup from standby

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Feb 19, 2018 at 8:18 AM, David Steele <david@xxxxxxxxxxxxx> wrote:
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.

OK so all data files would be copied from standby. Can you give me an example of the types of files that need to be copied from primary?
 
it's best to archive from the primary so a replication
failure does not affect your archiving.

Understood, just not something I can change in production primary at the moment. Hence looking to see about a quick one-off backup from standby.
 
Configuring pgBackRest, SSH, standby, and backup from standby are all
covered in the user guide.

Thanks, I've been through it a few times and played with some test backups from primary clones. I just ditched my master/replica clone setup but I'll test there as well. I just had a couple questions about the mechanics.



--
Don Seiler
www.seiler.us

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux