Content-Type: multipart/alternative;
 boundary="------------90Bl7QK2NiZzYrU4vQWh3GkO"
Message-ID: <9b3e4781-72fd-4a32-bf82-c4f2796017cd@yahoo.co.uk>
Date: Fri, 26 Jan 2024 15:17:40 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
To: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Content-Language: en-US
From: lejeczek <peljasz@yahoo.co.uk>
Subject: max_wal_senders - stuck on
References: <9b3e4781-72fd-4a32-bf82-c4f2796017cd.ref@yahoo.co.uk>
Content-Length: 2109
Archived-At: 
 <https://www.postgresql.org/message-id/9b3e4781-72fd-4a32-bf82-c4f2796017cd%40yahoo.co.uk>
Precedence: bulk

This is a multi-part message in MIME format.
--------------90Bl7QK2NiZzYrU4vQWh3GkO
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Hi guys.

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, where its value was 48.

and I've checked config files (I'm on Ubuntu with pgSQL 
14.10) - no _max_wal_senders_ set there.

All & any suggestions on what is happening there - much 
appreciated.
thanks, L.
--------------90Bl7QK2NiZzYrU4vQWh3GkO
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <font size="2" face="Courier 10 Pitch">Hi guys.<br>
      <br>
      I have I think pretty weird situation, my primary says:<br>
      <br>
      -&gt; $ sudo --login -u postgres psql --quiet --port=5435 -x -c
      'show max_wal_senders'<br>
      -[ RECORD 1 ]---+---<br>
      max_wal_senders | 10<br>
      <br>
      and slave when told to start, says:<br>
      ....<br>
      2024-01-26 15:13:14.315 CET [1279777] FATAL:  recovery aborted
      because of insufficient parameter settings<br>
      2024-01-26 15:13:14.315 CET [1279777] DETAIL:  max_wal_senders =
      10 is a lower setting than on the primary server, where its value
      was 48.<br>
      <br>
      and I've checked config files (I'm on Ubuntu with pgSQL 14.10) -
      no _</font><font size="2" face="Courier 10 Pitch">max_wal_senders_
      set there.<br>
      <br>
      All &amp; any suggestions on what is happening there - much
      appreciated.<br>
      thanks, L.<br>
    </font>
  </body>
</html>

--------------90Bl7QK2NiZzYrU4vQWh3GkO--