Re: max_wal_senders - stuck on - Mailing list pgsql-admin

From lejeczek
Subject Re: max_wal_senders - stuck on
Date
Msg-id 5a0b25d3-8d8c-4bc8-88f0-4f105737ee6e@yahoo.co.uk
Whole thread Raw
In response to Re: max_wal_senders - stuck on  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: max_wal_senders - stuck on
List pgsql-admin

On 26/01/2024 15:49, Laurenz Albe wrote:
> On Fri, 2024-01-26 at 15:17 +0100, lejeczek wrote:
>>   I have I think pretty weird situation, my primary says:
>>    -> $ sudo --login -u postgres psql --quiet --port=5435 -x -c 'show max_wal_senders'
>>   -[ RECORD 1 ]---+---
>>   max_wal_senders | 10
>>   
>>   and slave when told to start, says:
>>   ....
>>   2024-01-26 15:13:14.315 CET [1279777] FATAL:  recovery aborted because of insufficient parameter settings
>>   2024-01-26 15:13:14.315 CET [1279777] DETAIL:  max_wal_senders = 10 is a lower setting than on the primary server,
whereits value was 48.
 
>>
>>   and I've checked config files (I'm on Ubuntu with pgSQL 14.10) - no _max_wal_senders_ set there.
> Perhaps max_wal_senders was 48 earlier, and that value is logged in the WAL?
>
> Yours,
> Laurenz Albe
Yes, earlier it was, now removed - 10 is the default I guess 
- how to "fix" this? (possibly without _pg_base..._)
many thanks, L.



pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: max_wal_senders - stuck on
Next
From: Alvaro Herrera
Date:
Subject: Re: max_wal_senders - stuck on