| From: | milist ujang <ujang(dot)milist(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | BDR, wal segment has been removed, is it possible move forward? |
| Date: | 2017-09-05 17:52:14 |
| Message-ID: | CACG9ogyTF3wT2twNeFX-ToHvNOQkjkc_CNVgGn4fvKcjuCr3_A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2017-09-05 18:28:56 | Re: Postgresql init and cleanup module functions |
| Previous Message | Tom Lane | 2017-09-05 17:32:45 | Re: Accessiing database from inside of postgresql C function |