"FATAL","58P01","could not access file ""\$libdir/pgcrypto"": No such file or directory"

Products

• VMware Tanzu Data Suite
• VMware Tanzu Greenplum
• VMware Tanzu Greenplum / Gemfire
• VMware Tanzu Data Suite

Issue/Introduction

You followed the instructions at pgcrypto documentation to configure pgcrypto and it causes the database to fail with below error and not to start.

 

Changes applied -

[gpadmin@ltvidagpma01 gpv6seg-1]$ gpconfig -c shared_preload_libraries -v '\$libdir/pgcrypto'
20250516:16:28:00:1668924 gpconfig:ltvidagpma01:gpadmin-[INFO]:-completed successfully with parameters '-c shared_preload_libraries -v '\$libdir/pgcrypto''
[gpadmin@ltvidagpma01 gpv6seg-1]$ 

error seen in the startup.log file on master host.

2025-05-16 16:29:17.109832 EDT,,,p1672706,th-1064963456,,,,0,,,seg-1,,,,,"FATAL","58P01","could not access file ""\$libdir/pgcrypto"": No such file or directory",,,,,,,,"internal_load_library","dfmgr.c",202,1    0xbe54ef postgres errstart (elog.c:567)
2    0xbea90d postgres <symbol not found> (dfmgr.c:199)
3    0xbeafb4 postgres load_file (dfmgr.c:156)
4    0xbf4f6a postgres <symbol not found> (miscinit.c:1384)
5    0xbf60ce postgres process_shared_preload_libraries (miscinit.c:1405)
6    0xa24cc7 postgres PostmasterMain (postmaster.c:1147)
7    0x6e34cb postgres main (main.c:178)
8    0x7fd2bd07c8a5 libc.so.6 __libc_start_main + 0xe5
9    0x6ef3ce postgres _start + 0x2e

Resolution

Removing the backslash should resolve the issue.

Incorrect statement:
gpconfig -c shared_preload_libraries -v '\$libdir/pgcrypto'

Correct statement:
gpconfig -c shared_preload_libraries -v '$libdir/pgcrypto'