Re: Pgbackrest

Greetings,

* For(at)ll (forall(at)stalowka(dot)info) wrote:
> For now I use OmniPITR for backup and replication with postgresql, but
> we looking something else and I find pgbackrest, so I have a few questions:
>
> - use OmniPITR for streaming replication I have 2 way protection, when
> slave long time off,after start, postgresql restore data from wal before
> switching to the streamgin replication from postgresql.
> It's possible to do in pgbackrest?

Yes, when you do a restore with pgbackrest, the recovery.conf will be
set up to pull WAL from the repository to catch up.

> - in pgbackrest streaming replication it can be only with "async state"?

Note that pgbackrest doesn't use streaming replication for WAL as it's
too slow, we use archive_command instead (and will run multiple parallel
workers to get ahead of where archive_command is at, if there's WAL
available to process and parallel workers are configured).

It doesn't matter to pgbackrest if the replication between your primary
and replica is synchronous or asycnhronous.

Thanks!

Stephen