Re: pldbgapi extension

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(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
>