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@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>> 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@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
