Hi Team, Not able to create the extension pldbgapi in cluster and if i run make and make install it will going .sql file in /usr/share/pgsql/extension this path but actually i need to create these files into below path,
How to create this one please advise ==> psql psql (11.5) Type "help" for help. postgres=# CREATE EXTENSION pldbgapi; ERROR: could not open extension control file *"/usr/pgsql-11/share/extension/*pldbgapi.control": No such file or directory postgres=# postgres=# postgres=# \q [root@cvgrhehhsd006 pldebugger-master]# export PATH=$PGHOME/bin:$PATH:$HOME/.local/bin:$HOME/bin:$PGBASE/edbmtk/bin:/usr/pgsql-11/bin [root@cvgrhehhsd006 pldebugger-master]# make USE_PGXS=1 make: Nothing to be done for `all'. [root@cvgrhehhsd006 pldebugger-master]# [root@cvgrhehhsd006 pldebugger-master]# make install USE_PGXS=1 /usr/bin/mkdir -p '/usr/lib64/pgsql' /usr/bin/mkdir -p '/usr/share/pgsql/extension' /usr/bin/mkdir -p '/usr/share/pgsql/extension' /usr/bin/mkdir -p '/usr/share/doc/pgsql/extension' /bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m 755 plugin_debugger.so '/usr/lib64/pgsql/plugin_debugger.so' /bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m 644 ./pldbgapi.control '/usr/share/pgsql/extension/' /bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m 644 ./pldbgapi--1.0.sql ./pldbgapi--unpackaged--1.0.sql '/usr/share/pgsql/extension/' /bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c -m 644 ./README.pldebugger '/usr/share/doc/pgsql/extension/' [root@cvgrhehhsd006 pldebugger-master]# [root@cvgrhehhsd006 pldebugger-master]# cd /usr/share/pgsql/extension [root@cvgrhehhsd006 extension]# ls pldbgapi--1.0.sql pldbgapi.control pldbgapi--unpackaged--1.0.sql [root@cvgrhehhsd006 extension]# ll total 16 -rw-r--r--. 1 root root 7457 Sep 17 02:46 pldbgapi--1.0.sql -rw-r--r--. 1 root root 181 Sep 17 02:46 pldbgapi.control -rw-r--r--. 1 root root 2258 Sep 17 02:46 pldbgapi--unpackaged--1.0.sql -- Thanks, Prakash.R PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : +91-8939599426
