Re: pldbgapi extension - Mailing list pgsql-general

On 9/17/19 7:44 AM, Prakash Ramakrishnan wrote:
> I installed devel and contrib also but not worked here.

Yeah, --contrib won't help as pldbpgapi is not one of the contrib 
modules as found here:

https://www.postgresql.org/docs/11/contrib.html

The basic issue is you are using two install methods YUM for your 
Postgres server and source build for the pldbpgapi extension. They are 
using different directory structures. I think the best bet for the time 
being is to use the symklink suggestion I posted earlier. Someone with 
more experience with RH may also chime in with a better solution.

> 
> 
> Regards,
> Prakash.R
> 
> On Tue, Sep 17, 2019, 19:58 Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>      > <mailto:adrian.klaver@aklaver.com
>     <mailto:adrian.klaver@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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>     <mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>
>      >
> 
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com