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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com