Thread: passwordcheck_extra module on pg v14.6

passwordcheck_extra module on pg v14.6

From

Daulat

Date:

16 December 2022, 20:39:31

Hello Team,

I have tried to use the passwordcheck_extra module on pg v14.6 (Ubuntu 22.04) from Advanced Password Checks (paquier.xyz).

But getting below error message while restarting postgres after making changes (shared_preload_libraries = 'passwordcheck_extra') in postgresql.conf file. The same thing is working in pg10 but pg14.6 throws below error.

waiting for server to start....2022-12-16 12:37:27.203 UTC [20464] FATAL: could not load library "/opt/PostgreSQL-14/lib/postgresql/passwordcheck_extra.so": /opt/PostgreSQL-14/lib/postgresql/passwordcheck_extra.so: undefined symbol: elog_finish
2022-12-16 12:37:27.203 UTC [20464] LOG: database system is shut down
stopped waiting

Thanks.

Re: passwordcheck_extra module on pg v14.6

From

Tom Lane

Date:

16 December 2022, 21:13:32

Daulat <daulat.dba@gmail.com> writes:
> I have tried to use the passwordcheck_extra module on pg v14.6 (Ubuntu
> 22.04) from Advanced Password Checks (paquier.xyz)
> <https://paquier.xyz/postgresql-2/advanced-password-check/>.
> But getting below error message while restarting postgres after making
> changes (shared_preload_libraries = 'passwordcheck_extra')  in
> postgresql.conf file. The same thing is working in pg10 but pg14.6 throws
> below error.

You would need a version that is actually built against v14.
Postgres extension modules always require recompilation for
new major server versions.  (Sadly, the linker gets in the way
here before we're able to deliver an on-point error message.)

            regards, tom lane