How to install debugger in pg12

This article is about how pg12 installs debugger. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Postgresql12.2 installs the pldbgapi plug-in

Debugging requires the installation of plug-ins

Download the pldebugger installation package:

1. Install git

$yum install git

2. Enter the database installation directory / app/software/postgre/postgresql-12.2/contrib

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

3. Enter pldebugger

Cd pldebugger

4. Compile and install

Make USE_PGXS=1

Make USE_PGXS=1 install

5. Modify the configuration

Cd / app/software/postgre/postgresql-12.2/data

Vi postgresql.conf

The postgresql.conf file contains a lot of content. Enter / shared_preload_libraries directly to find the content.

Edit shared_preload_libraries ='$libdir/plugin_debugger' and delete the preceding #

6. Restart the database service

$/ app/software/postgre/postgresql-12.2/bin/pg_ctl restart-D / app/software/postgre/postgresql-12.2/data/-m fast

7. Install the pldbgapi plug-in in the target database

When compiling, the openssl library is required

Yum install openssl

Yum install openssl-devel

Install the opensl library

Thank you for reading! This is the end of this article on "how to install debugger in pg12". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!