Re: pldbgapi extension
От | Adrian Klaver |
---|---|
Тема | Re: pldbgapi extension |
Дата | |
Msg-id | edfbbaa2-b092-b27b-1061-388aa2c0df3e@aklaver.com обсуждение исходный текст |
Ответ на | Re: pldbgapi extension (Prakash Ramakrishnan <prakash.ramakrishnan.ap@nielsen.com>) |
Ответы |
Re: pldbgapi extension
|
Список | 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
В списке pgsql-general по дате отправления:
Предыдущее
От: Kevin WilkinsonДата:
Сообщение: Re: deadlock on declarative partitioned table (11.3)