Re: max_wal_senders - stuck on

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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, 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.
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.





[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux