On Thu, 04 Aug 2022 at 19:29, Daniel Verite <daniel@manitou-mail.org> wrote:
> Japin Li wrote:
>
>> However, if the database is in production, we cannot go into single-user
>> mode, should we provide an option to change this behavior on the fly?
>
> It already exists, through PGOPTIONS, which appears to work
> for local_preload_libraries, in a quick test.
>
> That is, you can log in by invoking psql with:
> PGOPTIONS="-c local_preload_libraries="
> and issue the ALTER USER to reset things back to normal
> without stopping the instance.
Oh, great! Thank you very much!
--
Regrads,
Japin Li.
ChengDu WenWu Information Technology Co.,Ltd.