Re: Streaming replication - 11.5

On 3/10/20 8:17 AM, Nicola Contu wrote:
Please post to list also.
Ccing list.

What came immediately before the temporary file error?

>    2020-03-10 15:10:17 GMT [[local]] [28171]: [1-1] 
> db=postgres,user=postgres LOG:  temporary file: path 
> "base/pgsql_tmp/pgsql_tmp28171.0", size 382474936
> 2020-03-10 15:10:17 GMT [[local]] [28171]: [4-1] 
> db=postgres,user=postgres LOG:  could not send data to client: Broken pipe
> 2020-03-10 15:10:17 GMT [[local]] [28171]: [5-1] 
> db=postgres,user=postgres FATAL:  connection to client lost
> 2020-03-10 15:10:26 GMT [] [12598]: [3544-1] db=,user= LOG: 
>   restartpoint complete: wrote 37315 buffers (0.4%); 0 WAL file(s) 
> added, 0 removed, 16 recycled; write=269.943 s, sync=0.039 s, 
> total=269.999 s; sync files=1010, longest=0.001 s, average=0.000 s; 
> distance=175940 kB, estimate=416149 kB
> 2020-03-10 15:10:26 GMT [] [12598]: [3545-1] db=,user= LOG:  recovery 
> restart point at 6424/1D7DEDE8
> 
> It is a cascade replication
> 
> Il giorno mar 10 mar 2020 alle ore 15:58 Adrian Klaver 
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> ha scritto:
> 
>     On 3/10/20 2:26 AM, Nicola Contu wrote:
>      > Hello,
>      > I have two servers connected to the same switch running postgres 11.5
>      >
>      > I am trying to replicate one of those servers after a planned
>     work on
>      > the master, so the replica has been lost. It has always worked
>     but now I
>      > get this :
>      >
>      > pg_basebackup: could not receive data from WAL stream: server
>     closed the
>      > connection unexpectedly
>      >          This probably means the server terminated abnormally
>      >          before or while processing the request.
>      >
>      > I don't really understand what the issue is.
> 
>     I would start with the logs from the Postgres server you are taking the
>     backup from.
> 
>      > I had this issue last week as well in another DC and I had to
>     reboot the
>      > slave to make it working (not sure why it helped)
>      >
>      > Do you know what can cause this?
>      >
>      > Thank you,
>      > Nicola
> 
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com