Re: Streaming replication - 11.5

From: Nicola Contu <nicola(dot)contu(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>, Alessandro Aste <Alessandro(dot)aste(at)gtt(dot)net>
Subject: Re: Streaming replication - 11.5
Date: 2020-03-13 11:11:09
Message-ID: CAMTZZh1giJXj09aBYYfe0hxSYkqY3JRW3=OdoPKRzRVkOKDptA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

So in the logs I now see this :

2020-03-13 11:03:42 GMT [10.150.20.22(45294)] [27804]: [1-1]
db=[unknown],user=replicator LOG: terminating walsender process due to
replication timeout

So I tried increasing the wal_sender_timeout to 300s but it did not help

Il giorno gio 12 mar 2020 alle ore 15:56 Nicola Contu <
nicola(dot)contu(at)gmail(dot)com> ha scritto:

> The encryption is at os level. So the drives are encrypted with a password
> where the db saves data
>
> Il gio 12 mar 2020, 15:51 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> ha
> scritto:
>
>> On 3/12/20 4:31 AM, Nicola Contu wrote:
>> > The replicator is ok and the replicated as well.
>> > %Cpu(s): 0.2 us, 1.0 sy, 0.0 ni, 94.8 id, 4.0 wa, 0.0 hi, 0.0 si,
>> > 0.0 st
>> >
>> > CPU is really low on both.
>> >
>> > I am running pg_basebackup again everytime.
>> > Any other suggestions?
>> >
>>
>> I have to believe their is a connection between changing to encrypting
>> the disks and your issues. Not sure what, but to help how is the
>> encryption being done and what program is being used?
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com
>>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Zwettler Markus (OIZ) 2020-03-13 13:41:28 vacuum full doubled database size
Previous Message Peter J. Holzer 2020-03-13 10:02:47 Re: PostgreSQL10.x client Vs. PostgreSQL 11.x server