Hi Adrian, I did it yum installation postgresql 11 from repo file.but I don't know why it's giving wrong path and symbolic link how to create it please advise.
Regards, Prakash.R On Tue, Sep 17, 2019, 19:10 Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 9/16/19 11:51 PM, Prakash Ramakrishnan wrote: > > 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 > > Questions: > > 1) OS and version? > > 2) How was Postgres installed? > > 3) How about symlinking /usr/share/pgsql/extension into > /usr/pgsql-11/share/extension/? > > > > > > ==> 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 > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
