Обсуждение: pldbgapi extension
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
==> 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
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
--
[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
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
Prakash Ramakrishnan <prakash.ramakrishnan.ap@nielsen.com> writes: > 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, If you're building from source with intention to match an existing installation, you need to be sure you've configured with the same options the existing installation was built with. The output of the installation's "pg_config" program should help. When building an out-of-tree extension using PGXS, in theory the PGXS infrastructure should get this right for you, but maybe it isn't, or you missed out using it. regards, tom lane
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.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
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>> 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> > -- Adrian Klaver adrian.klaver@aklaver.com
I installed devel and contrib also but not worked here.
Regards,
Prakash.R
On Tue, Sep 17, 2019, 19:58 Adrian Klaver <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>> 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>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
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
On 9/17/19 10:16 AM, Adrian Klaver wrote: > 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. > If OP is building the extension, why not build postgres too?
On 9/17/19 9:20 AM, Rob Sargent wrote: > > On 9/17/19 10:16 AM, Adrian Klaver wrote: >> 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. >> > If OP is building the extension, why not build postgres too? > Because installing from packages is easier? Looks like the module is available in the repo under a different name: https://yum.postgresql.org/testing/11/redhat/rhel-7-x86_64/repoview/pldebugger11.html -- Adrian Klaver adrian.klaver@aklaver.com
Yes debugging module is available in repo, installation from yum is very easy
Regards,
Siva.
On Tue, Sep 17, 2019, 10:50 PM Adrian Klaver <adrian.klaver@aklaver.com wrote:
On 9/17/19 9:20 AM, Rob Sargent wrote:
>
> On 9/17/19 10:16 AM, Adrian Klaver wrote:
>> 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.
>>
> If OP is building the extension, why not build postgres too?
>
Because installing from packages is easier?
Looks like the module is available in the repo under a different name:
https://yum.postgresql.org/testing/11/redhat/rhel-7-x86_64/repoview/pldebugger11.html
--
Adrian Klaver
adrian.klaver@aklaver.com