Additional syncing mechanisms

[sgotti]

Currently stolon only sync from primary using pg_basebackup since it's the most safe and easy way to do this.

We could add different syncing mechanisms (i.e. from backup, rsync etc...).

The difficult part of this different mechanisms is to check that the standby contains valid postgres data files (i.e. it was restored from the right backup).

[maksm90]

Hi @sgotti ! Is there anybody who is working on this issue?

[sgotti]

@maksm90 no one that I'm aware of.

[maksm90]

AFAICS it's necessary to implement an additional option to recover replica from third-party source similar to pitr mode of cluster initialization and enter this node into cluster. And config options have to duplicate the subset of PITRConfig, namely it have to comprise dataRestoreCommand and archiveRecoverySettings options. Right?

[sgotti]

@maksm90

AFAICS it's necessary to implement an additional option to recover replica from third-party source similar to pitr mode of cluster initialization and enter this node into cluster. And config options have to duplicate the subset of PITRConfig, namely it have to comprise dataRestoreCommand and archiveRecoverySettings options. Right?

This is a different RFE from this one. Currently replicas only sync from the primary. Please open a new RFE issue and/or a PR implementing this.

[maksm90]

This is a different RFE from this one. Currently replicas only sync from the primary. Please open a new RFE issue and/or a PR implementing this.

Done