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@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> 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@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
