From: lejeczek <peljasz@yahoo.co.uk>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: max_wal_senders - stuck on
Date: Fri, 26 Jan 2024 15:17:40 +0100
Message-ID: <9b3e4781-72fd-4a32-bf82-c4f2796017cd@yahoo.co.uk> (raw)
References: <9b3e4781-72fd-4a32-bf82-c4f2796017cd.ref@yahoo.co.uk>
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.
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: peljasz@yahoo.co.uk, pgsql-admin@lists.postgresql.org
Subject: Re: max_wal_senders - stuck on
In-Reply-To: <9b3e4781-72fd-4a32-bf82-c4f2796017cd@yahoo.co.uk>
* 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