Re: Streaming replication - 11.5

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Nicola Contu <nicola(dot)contu(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Cc: Alessandro Aste <Alessandro(dot)aste(at)gtt(dot)net>
Subject: Re: Streaming replication - 11.5
Date: 2020-03-10 14:58:08
Message-ID: 89a1e4cd-1da5-7233-d8c3-5e19cc9d1b75@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message PegoraroF10 2020-03-10 15:42:04 Re: How to discover what table is
Previous Message Adrian Klaver 2020-03-10 14:54:16 Re: How to discover what table is