Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] streaming replication - crash on standby - Mailing list pgsql-general

From Seong Son (US)
Subject [GENERAL] streaming replication - crash on standby
Date
Msg-id BY2PR17MB03282D3F74E7724DCA6807F2848B0@BY2PR17MB0328.namprd17.prod.outlook.com
Whole thread Raw
Responses Re: [GENERAL] streaming replication - crash on standby  (Andres Freund <andres@anarazel.de>)
List pgsql-general
Tree view

The last line from pg_xlogdump of the last WAL file on the crashed standby server shows the following.

 

pg_xlogdump: FATAL:  error in WAL record at DF/4CB95FD0: unexpected pageaddr DB/62B96000 in log segment 00000000000000DF0000004C, offset 12148736

 

I believe this means the standby server received WAL file out of order?  But why did it crash?  Is crashing normal behavior in case like this?

 

Thanks,

Seong

pgsql-general by date:

Previous
From: marcelo
Date:
Subject: Re: [GENERAL] ErrorCode=-2147467259 storing a .net string
Next
From: Andres Freund
Date:
Subject: Re: [GENERAL] Interesting streaming replication issue