Re: pldbgapi extension

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(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> > <mailto:adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(at)cvgrhehhsd006 pldebugger-master]# export
> >      >
> >
>  PATH=$PGHOME/bin:$PATH:$HOME/.local/bin:$HOME/bin:$PGBASE/edbmtk/bin:/usr/pgsql-11/bin
> >      > [root(at)cvgrhehhsd006 pldebugger-master]#  make USE_PGXS=1
> >      > make: Nothing to be done for `all'.
> >      > [root(at)cvgrhehhsd006 pldebugger-master]#
> >      > [root(at)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(at)cvgrhehhsd006 pldebugger-master]#
> >      > [root(at)cvgrhehhsd006 pldebugger-master]# cd
> /usr/share/pgsql/extension
> >      > [root(at)cvgrhehhsd006 extension]# ls
> >      > pldbgapi--1.0.sql  pldbgapi.control
>  pldbgapi--unpackaged--1.0.sql
> >      > [root(at)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> <mailto:adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com