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.
|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.
|Defines an alias for the connection. This alias is used to identify the connection when listing it on the connection's combo box.
|Initial database in which to connect. This is the first database to be accessed before starting to manage the others. Generally, this is the
|Automatically browses the named database when using this connection to handle databases in Manage view.
|Network address and port in which the server is listening. The host can be an IP address or an FQDN (fully qualified domain name).
|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 for the provided user account. If your server has enabled blank password authentication you can leave this field empty.
|Connection timeout (in seconds).
|Additional connection parameters specified by the user. The values specified in this field must be separated by blank spaces and have the form
|This set of checkboxes defines for which operations (diff, export, import, and validation) this connection is used by default.
|Tests the configured connection.
|Add the configured connection to the memory (currently loaded settings) in order to save it to the
connections.conf when Apply is pressed.
|Enables the use of SSL when connecting to the server. The fields
Revoked Certs. are used in conjunction with this one.
|Defines the server address for Kerberos-based authentication.
|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.