v1.1.0 Summary Chapter 4: Handling settings 4. Introduction 4.4. Connections settings

4.4. Connections settings

The connection settings widget handles the configuration of database connections to be used by several features on pgModeler. All the connection attributes are based upon the PostgreSQL client library parameters, thus you can get a detailed description of them in the official documentation.

General

Option/Action Description
Connections Stores all the configured connections. The control buttons at the right of the combo box have, respectively, the actions: add a new connection, duplicate, edit, and delete the selected connection.
Connection Alias Defines an alias for the connection. This alias is used to identify the connection when listing it on the connection's combo box.
Connection DB Initial database in which to connect. This is the first database to be accessed before starting to manage the others. Generally, this is the postgres database.
Auto browse Automatically browses the named database when using this connection to handle databases in Manage view.
Host/Port Network address and port in which the server is listening. The host can be an IP address or an FQDN (fully qualified domain name).
User The account used to access the initial database. It's recommended that this user has the needed permissions to create databases and read the system catalogs if you intend to use the export, import, and diff features.
Password Password for the provided user account. If your server has enabled blank password authentication you can leave this field empty.
Timeout Connection timeout (in seconds).
Other params Additional connection parameters specified by the user. The values specified in this field must be separated by blank spaces and have the form attribute=value .
Default for This set of checkboxes defines for which operations (diff, export, import, and validation) this connection is used by default.
Test button Tests the configured connection.
Add button Add the configured connection to the memory (currently loaded settings) in order to save it to the connections.conf when Apply is pressed.


Security

Option Description
SSL Mode Enables the use of SSL when connecting to the server. The fields Client, Certificate, Client Key, Root Certificate, Revoked Certs. are used in conjunction with this one.
Kerberos Server Defines the server address for Kerberos-based authentication.
Force GSSAPI This option has effect only when using Kerberos authentication and forces the connection to authenticate the credentials using the GSSAPI method.

WARNING: Connections' passwords are stored in plain text format in the settings. To avoid security issues, either prefer using SSL certificates in connections or make sure to protect the access to the directory where pgModeler settings are saved in the local user's storage (OS-dependent) from other users than the one running the tool. There are plans to use cryptography over stored passwords in future releases.

Feb 22, 2024 at 15:45