top of page

Configuring a connection to the PostgreSQL DBMS

The procedure for creating a connection to the PostgreSQL DBMS for its further use by both the monitoring system core, the query editor, and other program modules

Create a connection

You must first create a tree structure according to the instructions in the section "Buttons and connection tree management"

  • Select the node in the tree where you want to create a connection

  • Press the button '"Create new connect"

  • In field "Connection alias" enter a unique name within the node

  • From the drop down list "Database type" choose "PostgreSQL"

  • In field "VendorHome" leave blank

  • In field "VendorLib" specify the full path to the library libpq.dll. The path must be specified if it is necessary to use a PostgreSQL "client" other than the default one used by the program

  • In field "TNS_ADMIN" leave blank

  • In field "Comment" add connection description (optional)

Connection options
  • From the drop down list "Parameter name" select parameter name

  • In field "value" enter parameter value

  • Add parameter by clicking "Add parameter"

  • To delete a parameter, press the "Delete parameter"

To test the connection, click the "Testing connect"

To save the connection, click the "Save"

Description of parameters and possible values
server

Description: 

TCP/IP address or hostname of the server where the server is running PostgreSQL.

port

Description: 

The TCP/IP port that the server is listening on PostgreSQL.

database

Description: 

The name of the current database to connect to. If no database is specified, the current database is not configured.

User_Name

Description: 

User ID PostgreSQL.

Password

Description: 

User password PostgreSQL.

character set

Description: 

The default character set for the connection.

bottom of page