| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | "Seong Son (US)" <Seong(dot)Son(at)datapath(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: standby database crash |
| Date: | 2017-08-01 18:32:27 |
| Message-ID: | CAB7nPqSY17pzRGyEHz_E5rb=ZHZcNEVH2CVwS1xBq2skHBpvyQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Jul 31, 2017 at 11:15 PM, Seong Son (US) <Seong(dot)Son(at)datapath(dot)com> wrote:
> So my questions are, could an old WAL segment being resent through the
> network cause crash like this? Shouldn’t Postgresql be able to handle out
> of order WAL segments instead of just crashing?
When the streaming connection between a standby and a primary is cut,
the WAL receiver would restart and try to stream from the beginning of
the last segment it was in the middle of. See RequestXLogStreaming in
walreceiverfuncs.c.
> And what would be the best way to recover the standby server? Resynching
> the entire database seems to be too time consuming.
You may want to check the validity of the so-said WAL segment as well.
Corrupted data could come from it.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dan Cooperstock at Software4Nonprofits | 2017-08-01 18:35:11 | Re: Problem compiling a C function on Windows - not finding _palloc0@4 |
| Previous Message | Tom Lane | 2017-08-01 16:58:50 | Re: [GENERAL] Not able to create collation on Windows |