From: | Prakash Ramakrishnan <prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)com> |
---|---|
To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | pldbgapi extension |
Date: | 2019-09-17 06:51:36 |
Message-ID: | CAA2eZXxKw8q5GzYTcuarnbynheUqNbFSX_7a8FshgUYzp1OWmA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
[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
From | Date | Subject | |
---|---|---|---|
Next Message | Luca Ferrari | 2019-09-17 09:29:46 | Re: pgbackrest restore to new location? |
Previous Message | Ron | 2019-09-17 01:09:18 | pgbackrest restore to new location? |