pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedmax_wal_senders - stuck on
5+ messages / 4 participants
[nested] [flat]
* max_wal_senders - stuck on
@ 2024-01-26 14:17 lejeczek <peljasz@yahoo.co.uk>
0 siblings, 2 replies; 5+ messages in thread
From: lejeczek @ 2024-01-26 14:17 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: max_wal_senders - stuck on
@ 2024-01-26 14:24 David G. Johnston <david.g.johnston@gmail.com>
parent: lejeczek <peljasz@yahoo.co.uk>
1 sibling, 0 replies; 5+ messages in thread
From: David G. Johnston @ 2024-01-26 14:24 UTC (permalink / raw)
To: lejeczek <peljasz@yahoo.co.uk>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
On Friday, January 26, 2024, lejeczek <peljasz@yahoo.co.uk> wrote:
> 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.
>
>
The server/cluster the secondary is talking to isn’t the same
server/cluster that you ran the psql command against?
David J.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: max_wal_senders - stuck on
@ 2024-01-26 14:49 Laurenz Albe <laurenz.albe@cybertec.at>
parent: lejeczek <peljasz@yahoo.co.uk>
1 sibling, 1 reply; 5+ messages in thread
From: Laurenz Albe @ 2024-01-26 14:49 UTC (permalink / raw)
To: lejeczek <peljasz@yahoo.co.uk>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: max_wal_senders - stuck on
@ 2024-01-26 15:21 lejeczek <peljasz@yahoo.co.uk>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 5+ messages in thread
From: lejeczek @ 2024-01-26 15:21 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: max_wal_senders - stuck on
@ 2024-01-26 15:38 Alvaro Herrera <alvherre@alvh.no-ip.org>
parent: lejeczek <peljasz@yahoo.co.uk>
0 siblings, 0 replies; 5+ messages in thread
From: Alvaro Herrera @ 2024-01-26 15:38 UTC (permalink / raw)
To: lejeczek <peljasz@yahoo.co.uk>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
On 2024-Jan-26, lejeczek wrote:
> On 26/01/2024 15:49, Laurenz Albe wrote:
> > On Fri, 2024-01-26 at 15:17 +0100, lejeczek wrote:
> > > 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?
>
> Yes, earlier it was, now removed - 10 is the default I guess - how to "fix"
> this? (possibly without _pg_base..._)
Change the postgresql.conf config file in the replica to say
max_wal_senders=48 and start it. (You may have postgresql.auto.conf or
other files with the setting, which you'll have to remove or comment out).
--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2024-01-26 15:38 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-01-26 14:17 max_wal_senders - stuck on lejeczek <peljasz@yahoo.co.uk>
2024-01-26 14:24 ` David G. Johnston <david.g.johnston@gmail.com>
2024-01-26 14:49 ` Laurenz Albe <laurenz.albe@cybertec.at>
2024-01-26 15:21 ` lejeczek <peljasz@yahoo.co.uk>
2024-01-26 15:38 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
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