Plugin:org.tolven.postgresqlmgr

From DOC

Contents 1 Overview 2 Command Line 2.1 Test connection from admin to Postgresql 2.2 Simulate connection from appserver to Postgresql 2.3 Update Schemas In Postgresql 2.4 Update Indexes In Postgresql 3 Postgresql Manager GUI 3.1 Standalone GUI 3.2 Component Of Configuration Manager GUI 4 Version Notes 4.1 Version 0.0.8 4.2 Version 0.0.7 4.3 Version 0.0.6 4.4 Version 0.0.5 4.5 Version 0.0.4 4.6 Version 0.0.3 4.7 Version 0.0.2 4.8 Version 0.0.1

Overview

Command Line

Test connection from admin to Postgresql

This test attempts to connect to the database using the database superuser and the admin keystore for SSL.

tpf -plugin org.tolven.postgresqlmgr -testAdminDB

Simulate connection from appserver to Postgresql

This test attempts to connect to the database using the database superuser and the jboss keystore for SSL.

tpf -plugin org.tolven.postgresqlmgr -testAppServerDB

Update Schemas In Postgresql

The command is normally executed only once during initial configuration, but repeated execution causes no harm. This command is activated during the configPhase2 command where the database must already have been configured to work with Tolven. configPhase2 basically executes the command below (in addition to executing commands which update LDAP schemas). To update only the Postgresql schemas, you can execute the command below:

tpf -plugin org.tolven.postgresqlmgr -updateSchemas

Update Indexes In Postgresql

The command is normally executed only once during initial configuration, but repeated execution causes no harm. This command is activated during updateDBIndexes command where the database must already have been configured to work with Tolven and the application server must already have been started. updateDBIndexes basically executes the command below:

tpf -plugin org.tolven.postgresqlmgr -updateIndexes

Postgresql Manager GUI

Standalone GUI

tpf -plugin org.tolven.postgresqlmgr -gui

Component Of Configuration Manager GUI

GUI components like this one can be a component of a parent GUI. To make this plugin's GUI a child of org.tolven.configurationmgr, ensure that the following property appears in this plugin's entry in the <config-dir>/plugins.xml:

<plugin id="org.tolven.postgresqlmgr">
	<root />
	<property name="guiComponentParentId" value="org.tolven.configurationmgr" />
</plugin>

org.tolven.configurationmgr must also be in the <config-dir>/plugins.xml as a <root> plugin, so that it can be referenced. The sort order id is: org.tolven.postgresqlmgr_postgresql

Version Notes

Version 0.0.8

1. Added error message to indicate when a DB root password has not been stored in the password store, thus removing the NullPointerException

Version 0.0.7

1. Add index on MenuData.referenceId to facilitate faster access when looking for MenuData items that reference a placeholder.

Version 0.0.6

Add index for touch table (in public schema)

Version 0.0.5

1. Clarified output messages for the tests
2. Also writes messages to the tolven.log as well as stdout

Version 0.0.4

1. tolvenRemoteClient is now assembled during configPhase1, and placed in the public/download directory of the /Tolven context, where it can be automatically downloaded from the server via http to the installDir/remoteLib directory for use during the execution of configPhase3

Version 0.0.3

1. Placeholder ID index was updated to include menustructure_id. Requires updateIndexes to take effect.

Version 0.0.2

1. Added an option to updateSchemas and updateIndexes

Version 0.0.1

1. GUI for testing Postgresql connection