BDR, wal segment has been removed, is it possible move forward?

[milist ujang <ujang.milist@xxxxxxxxx>]

Hi all,

due to space issue and high volume transaction, some wal segments removed from pg_xlog on bdr environment.

warning log at node1 saying "requested WAL segment ..... has already been removed" following Connection reset by peer.

log at node2 :

Sending replication command: START_REPLICATION SLOT

...

...

XX000: data stream ended

I had played streams and goldengate (oracle product) , that at capture side we can move forward to certain sequence (archivedlog/redolog - wal segment in postgres).

So, is it possible to move forward to read recent wal segment in bdr environment? (assume data reconciliation will be done manually).

--

regards

ujang jaenudin | DBA Consultant (Freelancer)
http://ora62.wordpress.com
http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab