Search Postgresql Archives

Re: pgbackrest - question about restoring cluster to a new cluster on same server

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

 



On 9/18/19 10:18 PM, Jerry Sievers wrote:
> David Steele <david@xxxxxxxxxxxxx> writes:
> 
>> This is not an issue unless you seriously game the system.  When a
> 
> And/or your recovery system is running archive_mode=always :-)
> 
> I don't know how popular that setting value is but that plus an
> identical archive_command as the origin...  duplicate archival with
> whatever consequences.
> 
> Disclaimer: I don't know if pgbackrest guards against such a
> configuration.

We current disallow archive_mode=always because the locking issues are
complex.  Also, standbys will not always push WAL which is binary
identical to the primary (even though they are logically the same) so it
can be really tricky to tell who is authoritative.

We have plans in this area but they are currently on the back-burner.

Regards,
-- 
-David
david@xxxxxxxxxxxxx





[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