localhost:5432 admin@test=# set track_functions to 'all';
SET
localhost:5432 admin@test=# SELECT pg_reload_conf();
+----------------+
| pg_reload_conf |
+----------------+
| t |
+----------------+
(1 row)
localhost:5432 admin@test=# \c -
psql (15beta1 (Ubuntu 15~~devel~20220516.2230-1~803.git05a5a17.pgdg20.04+1), server 14.3 (Ubuntu 14.3-1.pgdg20.04+1))
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off)
You are now connected to database "test" as user "admin".
localhost:5432 admin@test=# show track_functions ;
+-----------------+
| track_functions |
+-----------------+
| none |
+-----------------+
(1 row)
重新连接后,track_function 返回到none
. 如何配置设置为all
一直?
set
仅更改当前会话的值。断开连接时它会丢失。如果您想跨会话(并且 Postgres 重新启动)保留更改,您需要使用 ALTER SYSTEM: