PostgreSQL 安裝 pldebugger USE_PGSX

PostgreSQL 安裝 pldebugger USE_PGSX

使用 USE_PGSX=1 make，在pldebugger編好後就會直接把編好的plugin_debugger.so和pldbgapi--1.0.sql放到/usr/pgsql-9.3相對應的位置。

yum install git readline-devel zlib-devel openssl-devel

cd /opt

wget http://ftp.postgresql.org/pub/source/v9.3.2/postgresql-9.3.2.tar.

tar xvzf postgresql-9.3.2.tar.gz

cd /opt/postgresql-9.3.2

USE_PGXS=1 ./configure

USE_PGXS=1 make

cd /opt/postgresql-9.3.2/contrib/

git clone git://git.postgresql.org/git/pldebugger.git

make 

cd /opt/postgresql-9.3.2/contrib/pldebugger

USE_PGXS=1 make

USE_PGXS=1 make install

[root@localhost pldebugger]# USE_PGXS=1 make install                                                                                                         gcc -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -I/usr/include/et -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fpic -shared -o plugin_debugger.so plpgsql_debugger.o plugin_debugger.o dbgcomm.o pldbgapi.o -L/usr/pgsql-9.3/lib -L/usr/lib64 -Wl,--as-needed

/bin/mkdir -p '/usr/pgsql-9.3/lib'

/bin/mkdir -p '/usr/pgsql-9.3/share/extension'

/bin/mkdir -p '/usr/pgsql-9.3/share/extension'

/bin/mkdir -p '/usr/share/doc/pgsql/extension'

/usr/bin/install -c -m 755  plugin_debugger.so '/usr/pgsql-9.3/lib/plugin_debugger.so'

/usr/bin/install -c -m 644 ./pldbgapi.control '/usr/pgsql-9.3/share/extension/'

/usr/bin/install -c -m 644 ./pldbgapi--1.0.sql ./pldbgapi--unpackaged--1.0.sql  '/usr/pgsql-9.3/share/extension/'

/usr/bin/install -c -m 644 ./README.pldebugger '/usr/share/doc/pgsql/extension/'

vim /var/lib/pgsql/9.3/data/postgresql.conf

加入下面的設定

shared_preload_libraries = '$libdir/plugin_debugger'

重新啟動

service postgresql-9.3 restart

安裝pldbgapi

su - postgres

psql

CREATE EXTENSION pldbgapi;

\dx

-bash-4.1$ psql

psql (9.3.2)

Type "help" for help.

postgres=# CREATE EXTENSION pldbgapi;

CREATE EXTENSION

postgres=# \dx

                              List of installed extensions

   Name    | Version |   Schema   |                     Description

-----------+---------+------------+------------------------------------------------------

adminpack | 1.0     | pg_catalog | administrative functions for PostgreSQL

pldbgapi  | 1.0     | public     | server-side support for debugging PL/pgSQL functions

plpgsql   | 1.0     | pg_catalog | PL/pgSQL procedural language

(3 rows)

================================================================
當pldebugger在USE_PGXS=1 make時出現下面的錯誤要安裝 openssl-devel套件，安裝好後再重新執行USE_PGXS=1 make

[root@localhost pldebugger]# USE_PGXS=1 make
gcc -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -I/usr/include/et -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fpic -I. -I. -I/usr/pgsql-9.3/include/server -I/usr/pgsql-9.3/include/internal -I/usr/include/et -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include  -c -o pldbgapi.o pldbgapi.c
In file included from pldbgapi.c:98:
/usr/pgsql-9.3/include/server/libpq/libpq-be.h:25:25: error: openssl/ssl.h: No such file or directory
/usr/pgsql-9.3/include/server/libpq/libpq-be.h:26:25: error: openssl/err.h: No such file or directory
/usr/pgsql-9.3/include/server/libpq/libpq-be.h:36:27: error: gssapi/gssapi.h: No such file or directory
In file included from pldbgapi.c:98:
/usr/pgsql-9.3/include/server/libpq/libpq-be.h:86: error: expected specifier-qualifier-list before ‘gss_buffer_desc’
/usr/pgsql-9.3/include/server/libpq/libpq-be.h:176: error: expected specifier-qualifier-list before ‘SSL’
make: *** [pldbgapi.o] Error 1