Question about user/database-level parameters - Mailing list pgsql-hackers

From Japin Li
Subject Question about user/database-level parameters
Date
Msg-id MEYP282MB166955E4B68992FC86C4DC48B69A9@MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: Question about user/database-level parameters
List pgsql-hackers
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
 

-- 
Regrads,
Japin Li.
ChengDu WenWu Information Technology Co.,Ltd.



pgsql-hackers by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: Add test of pg_prewarm extenion
Next
From: Pavel Borisov
Date:
Subject: Re: Trying to add more tests to gistbuild.c