gpdb icon indicating copy to clipboard operation
gpdb copied to clipboard

GPDB7 gpconfig fails to insert $libdir

Open kalensk opened this issue 11 months ago • 3 comments

The docs show the following example for inserting $libdir using gpconfig for GPDB7. But it fails for me as explained below. Can this be investigated and if needed made a priority to fix?

Docs https://docs.vmware.com/en/VMware-Greenplum/5/greenplum-database/utility_guide-admin_utilities-gpconfig.html

These examples shows the syntax required due to bash shell string processing.

gpconfig -c search_path -v '"\$user",public'
gpconfig -c dynamic_library_path -v '\$libdir'

The configuration parameters are added to the postgresql.conf file.

search_path='"$user",public'
dynamic_library_path='$libdir'

However running:

gpconfig -c dynamic_library_path -v '\$libdir'

Yields postgresql.conf with:

dynamic_library_path='\\'

I am unable to successfully get $libdir in postgresql.conf using gpconfig no matter what I try...

kalensk avatar Apr 02 '24 02:04 kalensk

What's the version of your server? The issue should be resolved by https://github.com/greenplum-db/gpdb/pull/16449

higuoxing avatar Apr 02 '24 02:04 higuoxing

What's the version of your server? The issue should be resolved by #16449

Let me try updating...

 PostgreSQL 12.12 (Greenplum Database 7.0.0-beta.3+dev.121.g75897b6d0f build dev) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.3.0-1ubuntu1~22.04.1) 11.3.0, 64-bit compiled on May 22 2023 19:04:02 (wi
th assert checking) Bhuvnesh C.
(1 row)

kalensk avatar Apr 02 '24 02:04 kalensk

Thanks! Updating to the latest HEAD of 7X seemed to work. However, the docs appear to be wrong and need updating. There is no need to escape the $.

The docs should be updated with: gpconfig -c dynamic_library_path -v '\$libdir'

Rather than: gpconfig -c dynamic_library_path -v '\$libdir'

kalensk avatar Apr 02 '24 02:04 kalensk