Online Documentation for SQL Manager for PostgreSQL

Setting specific options


This step of the wizard allows you to set the database alias, database options, logs and SSL parameters.

 

If the option CheckBox Register a single database has been selected on the first step, type the database name or select it from the drop-down list in the Database name field.

Use the Database alias field to set an alias for the registered database, which will be displayed in the DB Explorer and SQL Manager tools.

 

Register Database wizard - Setting specific options - Single database

 

The database(s) selected on the Selecting databases step will be displayed as a table showing the database name and its alias. You can modify the alias by clicking the corresponding table row.

 

Register Database wizard - Setting specific options - General

 

Database

 

Client encoding

This option allows you to use a multibyte encoding method in the database. Use the drop-down list to select the required encoding value, or leave this option <Not Set> to apply the default server encoding.

 

CheckBox Login prompt before connection

Enables SQL Manager for PostgreSQL to prompt for user name and password each time you connect to the database.

 

CheckBox Refresh objects on connection

This option allows you to enable/disable refreshing objects on connection to the database. It is highly recommended to uncheck this option if your database contains many objects or if the connection to the database is slow.

 

CheckBox Show system objects

If this option is checked, PostgreSQL system objects will be displayed in DB Explorer.

 

CheckBox Autoconnect at startup

With this option set, connection to the registered database is established automatically at application startup.

 

CheckBox Ping server every ... seconds

Defines minimal time interval for PostgreSQL server to be pinged. You may find this option useful in some cases.

 

Auth. method (*the option is only available in the x64 version of SQL Manager for PostgreSQL)

Select the authentication method when connecting to the database.

 

SSL

 

Register Database wizard - Setting specific options - SSL

 

Select the preferable SSL mode: Disabled, Allow, Prefer, Require, Verify CA, Verify Full.

 

Root certificate

Select the path to the client root.crt file.

 

Client certificate

Select the path to the client certificate.

 

Client key

Select the path to the client private key.

 

Revocation list

Select the file for Certificate Revocation List.

 

Logs

 

Register Database wizard - Setting specific options - Logs

 

CheckBox Enable log of metadata changes

Check this option if you wish to log metadata changes of your database in a file.

 

Log file

This field is enabled if the Enable log of metadata changes option is selected. Type in or use the Save as btnSaveAs button to specify the path to the *.sql file to store the metadata logs.

 

CheckBox Enable log of Query Data queries

Check this option if you wish to log your Query Data queries in a file.

 

Log file

This field is enabled if the Enable log of Query Data queries option is selected. Type in or use the Save as btnSaveAs button to specify the path to the *.sql file to store the logs of SQL queries.

 

CheckBox Is Unicode

Enable this option to save logs in Unicode. If the option is disabled, ANSI will be used.

 

Click the Finish button when done to start working with the newly registered database in SQL Manager for PostgreSQL.