Connection Settings
Connection Settings
(
) opens a Preferences Page that
allows entry of information necessary to create a database connection.
The Connection Settings Dialog
Selecting Connection Settings opens a dialog page with eight entries. These
items must be completed to succesfully connect to the PostgreSQL database.
-
JDBC File. Komo connects to
the PostgreSQL database through the JDBC interface. This option allows the
appropriate JDBC .jar file to be located, so that it can be used by Komo. Click
the Browse button to open a system browser and navigate to the file, or enter
it manually into the text field. Typically, the JDBC .jar file is located in a
subdirectory of the PostgreSQL program installation directory. If Komo is
being used to access a remote database (not located on the same computer as
Komo), the appropriate JDBC .jar file can be copied to a convenient location
on the computer where Komo is installed.
-
Server Port. The default
PostgreSQL port is 5432. If another port is used, it must be entered
here.
-
Server Address. PostgreSQL
is a client-server application and access requires a URL address to the
computer where PostgreSQL is installed. If PostgreSQL and Komo are
installed on the same computer, this is typically "localhost" (without the
quote marks).
-
SSL Connection. SSL stands
for Secure Socket Layer, a protocol for enabling a secure connection to the
PostgreSQL database. If PostgreSQL and Komo are installed on the same
computer, this option is not needed. If the PostgreSQL database is on a
remote computer, SSL can provide a more secure connection. To use SSL, this
feature must have been included in the PostgreSQL installation
build.
-
Database Name. The specific
name of the database to be accessed is entered here.
-
User Name. Each user
accessing a PostgreSQL database must have a unique name. This user name is
entered here.
-
User Password. Each user is
assigned a password that allows access to the PostgreSQL database while
maintaining security. It should be treated with the same care as the key to
your home or car. The user password may be entered on this line.
-
Store Password locally. If
this option is selected, the user password is stored in a file on the user's
computer. Although the file may be somewhat difficult to find, the password
is stored in plain text format and would be easily viewed. This represents a
potentially serious security risk. It is recommended that this option be
used only if you are quite certain that the computer is secure from hackers
and theft. If this option is not used, you will be asked to provide the
password once per session, when you initially connect to the database. Komo
will then remember the password for the duration of the session.