pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: lejeczek <peljasz@yahoo.co.uk>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: max_wal_senders - stuck on
Date: Fri, 26 Jan 2024 15:49:48 +0100
Message-ID: <2feeb2ea2d0c6164309fefa316d44442047e1db6.camel@cybertec.at> (raw)
In-Reply-To: <9b3e4781-72fd-4a32-bf82-c4f2796017cd@yahoo.co.uk>
References: <9b3e4781-72fd-4a32-bf82-c4f2796017cd.ref@yahoo.co.uk>
	<9b3e4781-72fd-4a32-bf82-c4f2796017cd@yahoo.co.uk>

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





view thread (5+ messages)  latest in thread

Message-ID: <2feeb2ea2d0c6164309fefa316d44442047e1db6.camel@cybertec.at>
Permalink:  ../2feeb2ea2d0c6164309fefa316d44442047e1db6.camel@cybertec.at/
Also on:    postgresql.org/message-id/2feeb2ea2d0c6164309fefa316d44442047e1db6.camel@cybertec.at

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: laurenz.albe@cybertec.at, peljasz@yahoo.co.uk, pgsql-admin@lists.postgresql.org
  Subject: Re: max_wal_senders - stuck on
  In-Reply-To: <2feeb2ea2d0c6164309fefa316d44442047e1db6.camel@cybertec.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox