Pgadmin How to do the mode

Pgadmin is an open source PostgreSQL client tool that meets the basic usage requirements of executives and developers. For example, create a new database, create database objects (tables, views, functions, etc.), database backup and restore, rights management, etc.

However, it does not support debugging by default in the development of stored procedures, and it is possible to set up a database extension. The main process is (CentOS 6.6, Postgresql 9.44)

1. Download Pldebugger plugin Git://git.postgresql.org/git/pldebugger.git

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

2. Copy the contents of the download to the contrib directory of the PostgreSQL source package (I am using PostgreSQL version 9.44)

3. Go to the Pldebugger directory and make the install after make done.

before this step, make sure that the following 2 things are done

1) The original code was carried out./configure--prefix= your PostgreSQL installation directory

2) Complete . Make after/configure but don't make instll .

4. Modify the postgresql.conf configuration file, remove the comment #shared_preload_libraries = ' ' and change to:

shared_preload_libraries = ' $libdir/plugin_debugger '
5. Restart the database service

/etc/init.d/postgresql SOTP

/etc/init.d/postgresql Start

can also be restarted with Pg_ctl, anyway restarted on the right, do not reload

6. Create an extension on the database to be adjusted, statement: "Create EXTENSION Pldbgapi;

7. If the version is more than 9.1, the Pldbgapi--1.0.sql method should be executed as follows:

psql-u postgres-w-D postgres-f/usr/local/plpgsql/share/extension/pldbgapi--1.0.sql

After doing this, go to pgadmin on the function right click on the right mouse button can appear debugging

650) this.width=650; "title=" Debug.png "src=" http://s3.51cto.com/wyfs02/M01/75/19/ Wkiol1yy1rztuwloaaquxykgvro967.jpg "alt=" Wkiol1yy1rztuwloaaquxykgvro967.jpg "/>

The above operation is relatively simple, other operations will not, if there is unclear can send e-mail to me [email protected]

The attachment is the Pldebugger project file I downloaded (2014-05-12 version), which can be used directly.

Report:

PostgreSQL website: http://www.postgresql.org/

Pgadmin Website: http://www.pgadmin.org/

Pldebugger Project website: http://git.postgresql.org/gitweb/?p=pldebugger.git;a=summary

This article is from the "Mirror" blog, please be sure to keep this source http://383133430.blog.51cto.com/454215/1707987

Pgadmin How to do the mode