I installed devel and contrib also but not worked here.
Regards, Prakash.R On Tue, Sep 17, 2019, 19:58 Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 9/17/19 7:20 AM, Prakash Ramakrishnan wrote: > > 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. > > Looks like it is installing to source built extension directory, not the > package one. > > You are using the PGDG repos? > > Did you install postgresql11-devel from the repo? > > I am not that familiar with the RH based multi-version install so I am > not sure that -devel will help or not, but it is worth a try. > > > > > > > Regards, > > Prakash.R > > > > On Tue, Sep 17, 2019, 19:10 Adrian Klaver <adrian.kla...@aklaver.com > > <mailto: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 <mailto:adrian.kla...@aklaver.com> > > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
