From: | Japin Li <japinli(at)hotmail(dot)com> |
---|---|
To: | Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: Question about user/database-level parameters |
Date: | 2022-08-02 05:33:22 |
Message-ID: | MEYP282MB1669C490557CA344B595E096B69D9@MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, 02 Aug 2022 at 13:01, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> wrote:
> At Mon, 01 Aug 2022 18:24:33 +0800, Japin Li <japinli(at)hotmail(dot)com> wrote in
>>
>> Hi, hackers
>>
>> When I try to modify the parameters for all users in the following command [1]
>> (the library doesn't exist), and I quit the connection, I cannot log in the
>> database, how can I bypass this checking?
>>
>> I find those parameters loaded by process_settings(), and it seems no way to
>> disable this loading process. If we could bypass this checking, how can we
>> fix these parameters?
>>
>> [1]
>> postgres=# ALTER ROLE all SET local_preload_libraries TO fdafd;
>> ALTER ROLE
>> postgres=# \q
>>
>> $ psql postgres
>> psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: could not access file "$libdir/plugins/fdafd": No such file or directory
>
> Can you run the server in single-user mode? That mode doesn't try
> loading libraries.
>
Yeah, the single-user mode works. Thank you very much!
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?
--
Regrads,
Japin Li.
ChengDu WenWu Information Technology Co.,Ltd.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2022-08-02 05:44:50 | Re: Question about user/database-level parameters |
Previous Message | John Naylor | 2022-08-02 05:28:21 | Re: fix typos |