database1Add my vote for this tag development1Add my vote for this tag integration1Add my vote for this tag create new tag
, view all tags


The plugin allows to generate a automatical documentatation of a PostgreSQL database, each time the topic is posted. It uses the system call postgresql_autodoc available on Linux OS. The postgresql_autodoc writes a HTML file in the plugin directory. The Plugin inserts the documentation content of the file into the topic.

Syntax Rules

The plugin synthax is:

%POSTGRESQLAUTODOC{host="host" [port="port"] database="database" user="user"}%

The host is the postgresql server, the port is the database server port, the database is the name of the database to connect to, the user is the login name for the database connection.

The Plugin checks if the logged-in TWiki user is allowed to make a database connection. The user must be listed in the TWiki configuration hash $TWiki::cfg{Plugins}{PostgreSqlAutoDocPlugin}{Acl} of the local TWiki configuration file lib/LocalSite.cfg:

# ACL's for the PostgreSqlAutoDoc plugin
$TWiki::cfg{Plugins}{PostgreSqAutoDocPlugin}{Acl} = "FirstnameLastname, ...";

If this is the case, the plugin makes a database connection as user user. The password is taken from the configuration file %POSTGRESQLSELECT_ACCESS in the home directory /%POSTGRESQLSELECT_HOME%/FirstnameLastname/ which must contain a line as:


This file must be readable for the Apache UID.

Changing the Layout

The layout of the postgresql_doc is controled by the Perl Template file /usr/share/postgresql-autodoc/html.tmpl. You find a proposed sample in the attachments.

Security Considerations

The plugin executes a system call, but forks the cgi process and executes the Perl exec command in the child process, so to by-pass the Bash interpreter, while reading the taint command arguments.

Be aware that only those TWiki users can execute the plugin, which are allowed to run the psql command on your database! You can controle the topic access that initialises the plugin with the TWiki ACL's:

    *  Set ALLOWTOPICVIEW = FirstnameLastname 

The plugin should be used with the Secure Socket Layer SSL.



Plugin Settings

  • One line description, is shown in the TextFormattingRules topic:
    • Set SHORTDESCRIPTION = Automatical documentation plugin for postgreSQL database

  • Debug plugin: (See output in data/debug.txt)
    • Set DEBUG = 0

  • Set the default postgresql port number:

  • Set the home directory:

  • Set the password access file:

Plugin Installation Instructions

  • Download the ZIP file from the Plugin web (see below)
  • Unzip PostgreSqlAutoDocPlugin.zip in your twiki installation directory. Content:
    File: Description:
    data/TWiki/PostgreSqlAutoDocPlugin.txt Plugin topic
    data/TWiki/PostgreSqlAutoDocPlugin.txt,v Plugin topic repository
    lib/TWiki/Plugins/PostgreSqlAutoDocPlugin.pm Plugin Perl module
    lib/TWiki/Plugins/PostgreSqlAutoDocPluginPlugin/PostgreSqlAutoDoc.pm Plugin main Perl CGI module
  • Define the ACL's hash $TWiki::cfg{Plugins}{PostgreSqlSelectPlugin}{Acl} in the TWiki locale configuration file lib/LocalSite.cfg.
  • Define in the user home directory /%POSTGRESQLSELECT_HOME% for database access file %POSTGRESQLSELECT_ACCESS% file (as descripted above).
  • Configure the Plugin:
    • TWiki 4.0 and up: Run the configure script to enable the Plugin
    • Change the Plugin settings as needed

Plugin Info

Plugin Author: TWiki:Main.RalfSchaer
Copyright: © 2006, TWiki:Main.RalfSchaer
License: GPL ( GNU General Public License)
Plugin Version: 1 Nov 2006 (V1.000)
Change History:
1 Nov 2006: Initial version
TWiki Dependency: $TWiki::Plugins::VERSION 1.1
CPAN Dependencies:  
Other Dependencies: postgresql_autodoc, fork, waitpid
Perl Version: 5
Benchmarks: GoodStyle nn%, FormattedSearch nn%, PostgreSqlAutoDocPlugin nn%
Plugin Home: http://TWiki.org/cgi-bin/view/Plugins/PostgreSqlAutoDocPlugin
Feedback: http://TWiki.org/cgi-bin/view/Plugins/PostgreSqlAutoDocPluginDev
Appraisal: http://TWiki.org/cgi-bin/view/Plugins/PostgreSqlAutoDocPluginAppraisal

Related Topics: TWikiPlugins, DeveloperDocumentationCategory, AdminDocumentationCategory, TWikiPreferences

-- TWiki:Main.RalfSchaer - 1 Nov 2006

Topic attachments
I Attachment History Action Size Date Who Comment
Compressed Zip archivezip PostgreSqlAutoDocPlugin.zip r1 manage 101.1 K 2006-11-02 - 08:04 RalfSchaer PostgreSql Auto Doc Plugin
Unknown file formattmpl html.tmpl r1 manage 10.3 K 2006-11-01 - 22:43 RalfSchaer postgresql_autodoc HTML Template
Edit | Attach | Watch | Print version | History: r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r3 - 2006-11-02 - PeterThoeny
  • Learn about TWiki  
  • Download TWiki
This site is powered by the TWiki collaboration platform Powered by Perl Hosted by OICcam.com Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2018 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.