Re: pldbgapi extension

I installed devel and contrib also but not worked here.

Regards,
Prakash.R

On Tue, Sep 17, 2019, 19:58 Adrian Klaver <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>> 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>
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>