Content Manager Enterprise Studio 24.4 Enterprise Studio

# Connection Settings dialog box for PostgreSQL

The Connection Settings dialog box for PostgreSQL appears when you click KwikSelect for the Database Connection String field in the Connection dialog box.

When using this dialog box for connecting to PostgreSQL via ODBC, the following information is required:

- Driver Name - select the appropriate ODBC driver to use.

NOTE: See CM24.4_Spec.pdf for specific requirements for PostgreSQL to enable you to decide what the correct option is for your setup.

- Server Name - the name or IP Address of the host running the instance of PostgreSQL.

NOTE: For a local install Server Name can be represented by ‘localhost’.

- Port Number - the port number of the host running the instance of PostgreSQL.
- Database Name - the name of the PostgreSQL database to be used.
- Schema Name - the name of the schema within PostgreSQL database to be used.
- User Name - the name of the user/role used to access the PostgreSQL database to be used.
- Password - enter the appropriate password for the User Name provided.
- SSL Mode - this option is dependent on your environment. Refer to the PostgreSQL documentation on this subject https://www.postgresql.org/docs/9.1/static/libpq-ssl.html
- Click the Test Connection button to verify these details.
  A message that the test connection succeeded will appear when the connection to the database is working. Otherwise, refer to your RDBMS documentation to resolve any errors that may occur.

Press OK to accept the details and return to the Connection dialog box.

Copyright 2008-2024 Open Text
Version 24.4 | Last updated October 2024
Contact

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to hprmdocumentation@microfocus.com.

We appreciate your feedback!

Product: Content Manager Enterprise Studio 24.4

Topic Title: Connection Settings dialog box for PostgreSQL