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