Re: Question about user/database-level parameters

    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.


Best regards,
--
Daniel Vérité
https://postgresql.verite.pro/
Twitter: @DanielVerite