Re: max_wal_senders - stuck on

Поиск
Список
Период
Сортировка
От lejeczek
Тема Re: max_wal_senders - stuck on
Дата
Msg-id 5a0b25d3-8d8c-4bc8-88f0-4f105737ee6e@yahoo.co.uk
обсуждение исходный текст
Ответ на Re: max_wal_senders - stuck on  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: max_wal_senders - stuck on  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-admin

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



В списке pgsql-admin по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: max_wal_senders - stuck on
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: max_wal_senders - stuck on