Request a Demo
Home   >   mailing lists

RE: POC: enable logical decoding when wal_level = 'replica' without a server restart - Mailing list pgsql-hackers

From Hayato Kuroda (Fujitsu)
Subject RE: POC: enable logical decoding when wal_level = 'replica' without a server restart
Date
Msg-id OSCPR01MB149667D5EF376E24A16E0429BF5E9A@OSCPR01MB14966.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: POC: enable logical decoding when wal_level = 'replica' without a server restart  (Masahiko Sawada <sawada.mshk@gmail.com>)
Responses Re: POC: enable logical decoding when wal_level = 'replica' without a server restart
List pgsql-hackers
Tree view 
Dear Sawada-san,

> It's not harmful in practice. I've considered waking up the postmaster
> with a new PMSignalReason, but I thought it's overkill to introduce a
> new reason just to wake up the postmaster. If there is a convenient
> way, I'd like to use that.

It's not straightforward, but can we reuse SIGHUP signal for the purpose? This
operation actually modifies the GUC parameter wal_level. One downside is that
postmaster will propagated it to all processes, which is not required.

Best regards,
Hayato Kuroda
FUJITSU LIMITED

pgsql-hackers by date:

Previous
From: Jim Jones
Date:
Subject: Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement
Next
From: Richard Guo
Date:
Subject: Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master