login_hook

在用户登陆时执行login_hook.login()函数

概览

扩展包名	版本	分类	许可证	语言
`login_hook`	`1.7`	SEC	GPL-3.0	C

ID	扩展名	Bin	Lib	Load	Create	Trust	Reloc	模式
7360	`login_hook`	否	是	否	是	否	否	`login_hook`

相关扩展	`pg_session_jwt` `pg_oidc_validator` `pgjwt` `oidc_validator` `pg_auth_mon` `auth_delay` `set_user` `pgsodium` `sslinfo` `sslutils`

版本

类型	仓库	版本	PG 大版本	包名	依赖
EXT	MIXED	`1.7`	1817161514	`login_hook`	-
RPM	PGDG	`1.7`	1817161514	`login_hook_$v`	-
DEB	PIGSTY	`1.7`	1817161514	`postgresql-$v-login-hook`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 1.7 el8.x86_64.pg18 : login_hook_18 login_hook_18-1.7-3PIGSTY.el8.x86_64.rpm PIGSTY · 1.7 · 17.7KiB	PGDG 1.7 el8.x86_64.pg17 : login_hook_17 login_hook_17-1.7-1PGDG.rhel8.x86_64.rpm PGDG · 1.7 · 18.1KiB login_hook_17-1.6-1PGDG.rhel8.x86_64.rpm PGDG · 1.6 · 17.6KiB	PGDG 1.7 el8.x86_64.pg16 : login_hook_16 login_hook_16-1.7-1PGDG.rhel8.x86_64.rpm PGDG · 1.7 · 17.9KiB login_hook_16-1.6-1PGDG.rhel8.x86_64.rpm PGDG · 1.6 · 17.4KiB login_hook_16-1.5-1PGDG.rhel8.x86_64.rpm PGDG · 1.5 · 16.7KiB	PGDG 1.7 el8.x86_64.pg15 : login_hook_15 login_hook_15-1.7-1PGDG.rhel8.x86_64.rpm PGDG · 1.7 · 17.9KiB login_hook_15-1.6-1PGDG.rhel8.x86_64.rpm PGDG · 1.6 · 17.4KiB login_hook_15-1.5-1PGDG.rhel8.x86_64.rpm PGDG · 1.5 · 16.7KiB	PGDG 1.7 el8.x86_64.pg14 : login_hook_14 login_hook_14-1.7-1PGDG.rhel8.x86_64.rpm PGDG · 1.7 · 18.0KiB login_hook_14-1.6-1PGDG.rhel8.x86_64.rpm PGDG · 1.6 · 17.5KiB login_hook_14-1.5-1PGDG.rhel8.x86_64.rpm PGDG · 1.5 · 16.7KiB
el8.aarch64	PIGSTY 1.7 el8.aarch64.pg18 : login_hook_18 login_hook_18-1.7-3PIGSTY.el8.aarch64.rpm PIGSTY · 1.7 · 17.9KiB	PGDG 1.7 el8.aarch64.pg17 : login_hook_17 login_hook_17-1.7-1PGDG.rhel8.aarch64.rpm PGDG · 1.7 · 18.1KiB login_hook_17-1.6-1PGDG.rhel8.aarch64.rpm PGDG · 1.6 · 17.5KiB	PGDG 1.7 el8.aarch64.pg16 : login_hook_16 login_hook_16-1.7-1PGDG.rhel8.aarch64.rpm PGDG · 1.7 · 17.9KiB login_hook_16-1.6-1PGDG.rhel8.aarch64.rpm PGDG · 1.6 · 17.4KiB login_hook_16-1.5-1PGDG.rhel8.aarch64.rpm PGDG · 1.5 · 16.6KiB	PGDG 1.7 el8.aarch64.pg15 : login_hook_15 login_hook_15-1.7-1PGDG.rhel8.aarch64.rpm PGDG · 1.7 · 17.9KiB login_hook_15-1.6-1PGDG.rhel8.aarch64.rpm PGDG · 1.6 · 17.4KiB login_hook_15-1.5-1PGDG.rhel8.aarch64.rpm PGDG · 1.5 · 16.6KiB	PGDG 1.7 el8.aarch64.pg14 : login_hook_14 login_hook_14-1.7-1PGDG.rhel8.aarch64.rpm PGDG · 1.7 · 17.9KiB login_hook_14-1.6-1PGDG.rhel8.aarch64.rpm PGDG · 1.6 · 17.4KiB login_hook_14-1.5-1PGDG.rhel8.aarch64.rpm PGDG · 1.5 · 16.7KiB
el9.x86_64	PIGSTY 1.7 el9.x86_64.pg18 : login_hook_18 login_hook_18-1.7-3PIGSTY.el9.x86_64.rpm PIGSTY · 1.7 · 17.7KiB	PGDG 1.7 el9.x86_64.pg17 : login_hook_17 login_hook_17-1.7-3PGDG.rhel9.8.x86_64.rpm PGDG · 1.7 · 18.4KiB login_hook_17-1.7-1PGDG.rhel9.x86_64.rpm PGDG · 1.7 · 18.3KiB login_hook_17-1.6-1PGDG.rhel9.x86_64.rpm PGDG · 1.6 · 17.8KiB	PGDG 1.7 el9.x86_64.pg16 : login_hook_16 login_hook_16-1.7-3PGDG.rhel9.8.x86_64.rpm PGDG · 1.7 · 18.3KiB login_hook_16-1.7-1PGDG.rhel9.x86_64.rpm PGDG · 1.7 · 18.1KiB login_hook_16-1.6-1PGDG.rhel9.x86_64.rpm PGDG · 1.6 · 17.6KiB login_hook_16-1.5-1PGDG.rhel9.x86_64.rpm PGDG · 1.5 · 16.7KiB	PGDG 1.7 el9.x86_64.pg15 : login_hook_15 login_hook_15-1.7-3PGDG.rhel9.8.x86_64.rpm PGDG · 1.7 · 18.3KiB login_hook_15-1.7-1PGDG.rhel9.x86_64.rpm PGDG · 1.7 · 18.1KiB login_hook_15-1.6-1PGDG.rhel9.x86_64.rpm PGDG · 1.6 · 17.6KiB login_hook_15-1.5-1PGDG.rhel9.x86_64.rpm PGDG · 1.5 · 16.7KiB	PGDG 1.7 el9.x86_64.pg14 : login_hook_14 login_hook_14-1.7-3PGDG.rhel9.8.x86_64.rpm PGDG · 1.7 · 18.3KiB login_hook_14-1.7-1PGDG.rhel9.x86_64.rpm PGDG · 1.7 · 18.2KiB login_hook_14-1.6-1PGDG.rhel9.x86_64.rpm PGDG · 1.6 · 17.7KiB login_hook_14-1.5-1PGDG.rhel9.x86_64.rpm PGDG · 1.5 · 16.8KiB
el9.aarch64	PIGSTY 1.7 el9.aarch64.pg18 : login_hook_18 login_hook_18-1.7-3PIGSTY.el9.aarch64.rpm PIGSTY · 1.7 · 17.7KiB	PGDG 1.7 el9.aarch64.pg17 : login_hook_17 login_hook_17-1.7-3PGDG.rhel9.8.aarch64.rpm PGDG · 1.7 · 18.3KiB login_hook_17-1.7-1PGDG.rhel9.aarch64.rpm PGDG · 1.7 · 18.1KiB login_hook_17-1.6-1PGDG.rhel9.aarch64.rpm PGDG · 1.6 · 17.5KiB	PGDG 1.7 el9.aarch64.pg16 : login_hook_16 login_hook_16-1.7-3PGDG.rhel9.8.aarch64.rpm PGDG · 1.7 · 18.1KiB login_hook_16-1.7-1PGDG.rhel9.aarch64.rpm PGDG · 1.7 · 17.9KiB login_hook_16-1.6-1PGDG.rhel9.aarch64.rpm PGDG · 1.6 · 17.4KiB login_hook_16-1.5-1PGDG.rhel9.aarch64.rpm PGDG · 1.5 · 16.4KiB	PGDG 1.7 el9.aarch64.pg15 : login_hook_15 login_hook_15-1.7-3PGDG.rhel9.8.aarch64.rpm PGDG · 1.7 · 18.1KiB login_hook_15-1.7-1PGDG.rhel9.aarch64.rpm PGDG · 1.7 · 17.9KiB login_hook_15-1.6-1PGDG.rhel9.aarch64.rpm PGDG · 1.6 · 17.4KiB login_hook_15-1.5-1PGDG.rhel9.aarch64.rpm PGDG · 1.5 · 16.4KiB	PGDG 1.7 el9.aarch64.pg14 : login_hook_14 login_hook_14-1.7-3PGDG.rhel9.8.aarch64.rpm PGDG · 1.7 · 18.1KiB login_hook_14-1.7-1PGDG.rhel9.aarch64.rpm PGDG · 1.7 · 18.0KiB login_hook_14-1.6-1PGDG.rhel9.aarch64.rpm PGDG · 1.6 · 17.4KiB login_hook_14-1.5-1PGDG.rhel9.aarch64.rpm PGDG · 1.5 · 16.4KiB
el10.x86_64	PIGSTY 1.7 el10.x86_64.pg18 : login_hook_18 login_hook_18-1.7-3PIGSTY.el10.x86_64.rpm PIGSTY · 1.7 · 17.7KiB	PGDG 1.7 el10.x86_64.pg17 : login_hook_17 login_hook_17-1.7-3PGDG.rhel10.2.x86_64.rpm PGDG · 1.7 · 18.5KiB login_hook_17-1.7-1PGDG.rhel10.x86_64.rpm PGDG · 1.7 · 18.6KiB	PGDG 1.7 el10.x86_64.pg16 : login_hook_16 login_hook_16-1.7-3PGDG.rhel10.2.x86_64.rpm PGDG · 1.7 · 18.4KiB login_hook_16-1.7-1PGDG.rhel10.x86_64.rpm PGDG · 1.7 · 18.5KiB	PGDG 1.7 el10.x86_64.pg15 : login_hook_15 login_hook_15-1.7-3PGDG.rhel10.2.x86_64.rpm PGDG · 1.7 · 18.4KiB login_hook_15-1.7-1PGDG.rhel10.x86_64.rpm PGDG · 1.7 · 18.5KiB	PGDG 1.7 el10.x86_64.pg14 : login_hook_14 login_hook_14-1.7-3PGDG.rhel10.2.x86_64.rpm PGDG · 1.7 · 18.4KiB login_hook_14-1.7-1PGDG.rhel10.x86_64.rpm PGDG · 1.7 · 18.5KiB
el10.aarch64	PIGSTY 1.7 el10.aarch64.pg18 : login_hook_18 login_hook_18-1.7-3PIGSTY.el10.aarch64.rpm PIGSTY · 1.7 · 17.8KiB	PGDG 1.7 el10.aarch64.pg17 : login_hook_17 login_hook_17-1.7-3PGDG.rhel10.2.aarch64.rpm PGDG · 1.7 · 18.5KiB login_hook_17-1.7-1PGDG.rhel10.aarch64.rpm PGDG · 1.7 · 18.6KiB	PGDG 1.7 el10.aarch64.pg16 : login_hook_16 login_hook_16-1.7-3PGDG.rhel10.2.aarch64.rpm PGDG · 1.7 · 18.4KiB login_hook_16-1.7-1PGDG.rhel10.aarch64.rpm PGDG · 1.7 · 18.5KiB	PGDG 1.7 el10.aarch64.pg15 : login_hook_15 login_hook_15-1.7-3PGDG.rhel10.2.aarch64.rpm PGDG · 1.7 · 18.4KiB login_hook_15-1.7-1PGDG.rhel10.aarch64.rpm PGDG · 1.7 · 18.5KiB	PGDG 1.7 el10.aarch64.pg14 : login_hook_14 login_hook_14-1.7-3PGDG.rhel10.2.aarch64.rpm PGDG · 1.7 · 18.4KiB login_hook_14-1.7-1PGDG.rhel10.aarch64.rpm PGDG · 1.7 · 18.5KiB
d12.x86_64	PIGSTY 1.7 d12.x86_64.pg18 : postgresql-18-login-hook postgresql-18-login-hook_1.7-2PIGSTY~bookworm_amd64.deb PIGSTY · 1.7 · 27.7KiB	PIGSTY 1.7 d12.x86_64.pg17 : postgresql-17-login-hook postgresql-17-login-hook_1.7-2PIGSTY~bookworm_amd64.deb PIGSTY · 1.7 · 27.7KiB	PIGSTY 1.7 d12.x86_64.pg16 : postgresql-16-login-hook postgresql-16-login-hook_1.7-2PIGSTY~bookworm_amd64.deb PIGSTY · 1.7 · 27.2KiB	PIGSTY 1.7 d12.x86_64.pg15 : postgresql-15-login-hook postgresql-15-login-hook_1.7-2PIGSTY~bookworm_amd64.deb PIGSTY · 1.7 · 27.2KiB	PIGSTY 1.7 d12.x86_64.pg14 : postgresql-14-login-hook postgresql-14-login-hook_1.7-2PIGSTY~bookworm_amd64.deb PIGSTY · 1.7 · 27.3KiB
d12.aarch64	PIGSTY 1.7 d12.aarch64.pg18 : postgresql-18-login-hook postgresql-18-login-hook_1.7-2PIGSTY~bookworm_arm64.deb PIGSTY · 1.7 · 27.6KiB	PIGSTY 1.7 d12.aarch64.pg17 : postgresql-17-login-hook postgresql-17-login-hook_1.7-2PIGSTY~bookworm_arm64.deb PIGSTY · 1.7 · 27.6KiB	PIGSTY 1.7 d12.aarch64.pg16 : postgresql-16-login-hook postgresql-16-login-hook_1.7-2PIGSTY~bookworm_arm64.deb PIGSTY · 1.7 · 27.1KiB	PIGSTY 1.7 d12.aarch64.pg15 : postgresql-15-login-hook postgresql-15-login-hook_1.7-2PIGSTY~bookworm_arm64.deb PIGSTY · 1.7 · 27.1KiB	PIGSTY 1.7 d12.aarch64.pg14 : postgresql-14-login-hook postgresql-14-login-hook_1.7-2PIGSTY~bookworm_arm64.deb PIGSTY · 1.7 · 27.2KiB
d13.x86_64	PIGSTY 1.7 d13.x86_64.pg18 : postgresql-18-login-hook postgresql-18-login-hook_1.7-2PIGSTY~trixie_amd64.deb PIGSTY · 1.7 · 27.7KiB	PIGSTY 1.7 d13.x86_64.pg17 : postgresql-17-login-hook postgresql-17-login-hook_1.7-2PIGSTY~trixie_amd64.deb PIGSTY · 1.7 · 27.6KiB	PIGSTY 1.7 d13.x86_64.pg16 : postgresql-16-login-hook postgresql-16-login-hook_1.7-2PIGSTY~trixie_amd64.deb PIGSTY · 1.7 · 27.2KiB	PIGSTY 1.7 d13.x86_64.pg15 : postgresql-15-login-hook postgresql-15-login-hook_1.7-2PIGSTY~trixie_amd64.deb PIGSTY · 1.7 · 27.2KiB	PIGSTY 1.7 d13.x86_64.pg14 : postgresql-14-login-hook postgresql-14-login-hook_1.7-2PIGSTY~trixie_amd64.deb PIGSTY · 1.7 · 27.4KiB
d13.aarch64	PIGSTY 1.7 d13.aarch64.pg18 : postgresql-18-login-hook postgresql-18-login-hook_1.7-2PIGSTY~trixie_arm64.deb PIGSTY · 1.7 · 27.6KiB	PIGSTY 1.7 d13.aarch64.pg17 : postgresql-17-login-hook postgresql-17-login-hook_1.7-2PIGSTY~trixie_arm64.deb PIGSTY · 1.7 · 27.6KiB	PIGSTY 1.7 d13.aarch64.pg16 : postgresql-16-login-hook postgresql-16-login-hook_1.7-2PIGSTY~trixie_arm64.deb PIGSTY · 1.7 · 27.2KiB	PIGSTY 1.7 d13.aarch64.pg15 : postgresql-15-login-hook postgresql-15-login-hook_1.7-2PIGSTY~trixie_arm64.deb PIGSTY · 1.7 · 27.1KiB	PIGSTY 1.7 d13.aarch64.pg14 : postgresql-14-login-hook postgresql-14-login-hook_1.7-2PIGSTY~trixie_arm64.deb PIGSTY · 1.7 · 27.2KiB
u22.x86_64	PIGSTY 1.7 u22.x86_64.pg18 : postgresql-18-login-hook postgresql-18-login-hook_1.7-2PIGSTY~jammy_amd64.deb PIGSTY · 1.7 · 29.2KiB	PIGSTY 1.7 u22.x86_64.pg17 : postgresql-17-login-hook postgresql-17-login-hook_1.7-2PIGSTY~jammy_amd64.deb PIGSTY · 1.7 · 29.6KiB	PIGSTY 1.7 u22.x86_64.pg16 : postgresql-16-login-hook postgresql-16-login-hook_1.7-2PIGSTY~jammy_amd64.deb PIGSTY · 1.7 · 29.0KiB	PIGSTY 1.7 u22.x86_64.pg15 : postgresql-15-login-hook postgresql-15-login-hook_1.7-2PIGSTY~jammy_amd64.deb PIGSTY · 1.7 · 29.0KiB	PIGSTY 1.7 u22.x86_64.pg14 : postgresql-14-login-hook postgresql-14-login-hook_1.7-2PIGSTY~jammy_amd64.deb PIGSTY · 1.7 · 29.3KiB
u22.aarch64	PIGSTY 1.7 u22.aarch64.pg18 : postgresql-18-login-hook postgresql-18-login-hook_1.7-2PIGSTY~jammy_arm64.deb PIGSTY · 1.7 · 29.1KiB	PIGSTY 1.7 u22.aarch64.pg17 : postgresql-17-login-hook postgresql-17-login-hook_1.7-2PIGSTY~jammy_arm64.deb PIGSTY · 1.7 · 29.5KiB	PIGSTY 1.7 u22.aarch64.pg16 : postgresql-16-login-hook postgresql-16-login-hook_1.7-2PIGSTY~jammy_arm64.deb PIGSTY · 1.7 · 28.9KiB	PIGSTY 1.7 u22.aarch64.pg15 : postgresql-15-login-hook postgresql-15-login-hook_1.7-2PIGSTY~jammy_arm64.deb PIGSTY · 1.7 · 28.9KiB	PIGSTY 1.7 u22.aarch64.pg14 : postgresql-14-login-hook postgresql-14-login-hook_1.7-2PIGSTY~jammy_arm64.deb PIGSTY · 1.7 · 29.1KiB
u24.x86_64	PIGSTY 1.7 u24.x86_64.pg18 : postgresql-18-login-hook postgresql-18-login-hook_1.7-2PIGSTY~noble_amd64.deb PIGSTY · 1.7 · 28.8KiB	PIGSTY 1.7 u24.x86_64.pg17 : postgresql-17-login-hook postgresql-17-login-hook_1.7-2PIGSTY~noble_amd64.deb PIGSTY · 1.7 · 28.8KiB	PIGSTY 1.7 u24.x86_64.pg16 : postgresql-16-login-hook postgresql-16-login-hook_1.7-2PIGSTY~noble_amd64.deb PIGSTY · 1.7 · 28.2KiB	PIGSTY 1.7 u24.x86_64.pg15 : postgresql-15-login-hook postgresql-15-login-hook_1.7-2PIGSTY~noble_amd64.deb PIGSTY · 1.7 · 28.2KiB	PIGSTY 1.7 u24.x86_64.pg14 : postgresql-14-login-hook postgresql-14-login-hook_1.7-2PIGSTY~noble_amd64.deb PIGSTY · 1.7 · 28.4KiB
u24.aarch64	PIGSTY 1.7 u24.aarch64.pg18 : postgresql-18-login-hook postgresql-18-login-hook_1.7-2PIGSTY~noble_arm64.deb PIGSTY · 1.7 · 28.6KiB	PIGSTY 1.7 u24.aarch64.pg17 : postgresql-17-login-hook postgresql-17-login-hook_1.7-2PIGSTY~noble_arm64.deb PIGSTY · 1.7 · 28.6KiB	PIGSTY 1.7 u24.aarch64.pg16 : postgresql-16-login-hook postgresql-16-login-hook_1.7-2PIGSTY~noble_arm64.deb PIGSTY · 1.7 · 28.0KiB	PIGSTY 1.7 u24.aarch64.pg15 : postgresql-15-login-hook postgresql-15-login-hook_1.7-2PIGSTY~noble_arm64.deb PIGSTY · 1.7 · 28.0KiB	PIGSTY 1.7 u24.aarch64.pg14 : postgresql-14-login-hook postgresql-14-login-hook_1.7-2PIGSTY~noble_arm64.deb PIGSTY · 1.7 · 28.1KiB
u26.x86_64	PIGSTY 1.7 u26.x86_64.pg18 : postgresql-18-login-hook postgresql-18-login-hook_1.7-2PIGSTY~resolute_amd64.deb PIGSTY · 1.7 · 27.6KiB	PIGSTY 1.7 u26.x86_64.pg17 : postgresql-17-login-hook postgresql-17-login-hook_1.7-2PIGSTY~resolute_amd64.deb PIGSTY · 1.7 · 27.5KiB	PIGSTY 1.7 u26.x86_64.pg16 : postgresql-16-login-hook postgresql-16-login-hook_1.7-2PIGSTY~resolute_amd64.deb PIGSTY · 1.7 · 27.0KiB	PIGSTY 1.7 u26.x86_64.pg15 : postgresql-15-login-hook postgresql-15-login-hook_1.7-2PIGSTY~resolute_amd64.deb PIGSTY · 1.7 · 27.0KiB	PIGSTY 1.7 u26.x86_64.pg14 : postgresql-14-login-hook postgresql-14-login-hook_1.7-2PIGSTY~resolute_amd64.deb PIGSTY · 1.7 · 27.2KiB
u26.aarch64	PIGSTY 1.7 u26.aarch64.pg18 : postgresql-18-login-hook postgresql-18-login-hook_1.7-2PIGSTY~resolute_arm64.deb PIGSTY · 1.7 · 27.4KiB	PIGSTY 1.7 u26.aarch64.pg17 : postgresql-17-login-hook postgresql-17-login-hook_1.7-2PIGSTY~resolute_arm64.deb PIGSTY · 1.7 · 27.4KiB	PIGSTY 1.7 u26.aarch64.pg16 : postgresql-16-login-hook postgresql-16-login-hook_1.7-2PIGSTY~resolute_arm64.deb PIGSTY · 1.7 · 26.9KiB	PIGSTY 1.7 u26.aarch64.pg15 : postgresql-15-login-hook postgresql-15-login-hook_1.7-2PIGSTY~resolute_arm64.deb PIGSTY · 1.7 · 26.9KiB	PIGSTY 1.7 u26.aarch64.pg14 : postgresql-14-login-hook postgresql-14-login-hook_1.7-2PIGSTY~resolute_arm64.deb PIGSTY · 1.7 · 27.0KiB

构建

您可以使用 pig build 命令构建 login_hook 扩展的 RPM / DEB 包：

BASH

pig build pkg login_hook         # 构建 RPM / DEB 包

安装

您可以直接安装 login_hook 扩展包的预置二进制包，首先确保 PGDG 和 PIGSTY 仓库已经添加并启用：

BASH

pig repo add pgsql -u          # 添加仓库并更新缓存

使用 pig 或者是 apt/yum/dnf 安装扩展：

安装

BASH

pig install login_hook;          # 当前活跃 PG 版本安装

pig

BASH

pig ext install -y login_hook -v 18  # PG 18
pig ext install -y login_hook -v 17  # PG 17
pig ext install -y login_hook -v 16  # PG 16
pig ext install -y login_hook -v 15  # PG 15
pig ext install -y login_hook -v 14  # PG 14

dnf

BASH

dnf install -y login_hook_18       # PG 18
dnf install -y login_hook_17       # PG 17
dnf install -y login_hook_16       # PG 16
dnf install -y login_hook_15       # PG 15
dnf install -y login_hook_14       # PG 14

apt

BASH

apt install -y postgresql-18-login-hook   # PG 18
apt install -y postgresql-17-login-hook   # PG 17
apt install -y postgresql-16-login-hook   # PG 16
apt install -y postgresql-15-login-hook   # PG 15
apt install -y postgresql-14-login-hook   # PG 14

创建扩展：

SQL

CREATE EXTENSION login_hook;

用法

login_hook: 在用户登录时执行代码，类似于 Oracle 的 after logon 触发器

login_hook 允许在用户登录数据库时执行自定义 PL/pgSQL 代码。

SQL

CREATE EXTENSION login_hook;

配置

添加到 postgresql.conf：

INI

session_preload_libraries = 'login_hook'

创建登录函数

定义一个 login_hook.login() 函数，该函数将在每次登录时执行：

SQL

CREATE OR REPLACE FUNCTION login_hook.login() RETURNS VOID LANGUAGE PLPGSQL AS $$
BEGIN
    IF NOT login_hook.is_executing_login_hook() THEN
        RAISE EXCEPTION 'Should only be invoked by login_hook';
    END IF;

    -- 你的登录逻辑：
    RAISE NOTICE 'Hello %', current_user;

EXCEPTION
    WHEN OTHERS THEN
        RAISE LOG 'Error in login_hook.login(): %', SQLERRM;
END
$$;
GRANT EXECUTE ON FUNCTION login_hook.login() TO PUBLIC;

需要 PUBLIC 授权，因为该函数会为每个连接用户运行。

函数

函数	返回类型	描述
`login_hook.is_executing_login_hook()`	`boolean`	仅在登录钩子执行期间调用时返回 true
`login_hook.get_login_hook_version()`	`text`	返回 login_hook 的编译版本
`login_hook.login()`	`void`	用户提供的在登录时执行的函数

重要说明

该函数不会在后台进程或恢复模式期间被调用
在函数内部处理所有异常 —— 失败将阻止普通用户登录
超级用户在函数失败时会收到警告但仍可登录
对于 PostgreSQL 17+，可考虑使用原生登录事件触发器

意见反馈

这个页面对您有帮助吗？

感谢反馈！请告诉我们如何改进。

抱歉给您带来不便。请告诉我们如何改进。