PostgreSQL database

Starting with version 25.2, Connect exclusively supports PostgreSQL as the database, and Derby is officially deprecated. PostgreSQL offers significant advantages including better performance, improved scalability, and enhanced reliability for enterprise environments.

PostgreSQL system requirements

The database can be installed on the same server as Connect, or on a dedicated server.

If PostgreSQL is installed on the same server as Connect, the requirements for Connect include adequate capabilities for PostgreSQL.

If PostgreSQL is installed on a dedicated server, there are no official minimal system requirements for PostgreSQL. We recommend having at least the following:

1 GHz processor
2 GB of RAM
512 MB of disk space

Download and install PostgreSQL

Note: The currently supported PostgreSQL version is v16.

To download and install PostgreSQL, go to the PostgreSQL download page and select your operating system. For installation instructions, refer to the PostgreSQL documentation.

After installation, verify that you can connect to PostgreSQL to ensure that the connection is active. You can do this by running the following command:

`psql -h <hostname> -p <port> -U <username> -d <database>`

If you encounter any errors, refer to the PostgreSQL documentation for troubleshooting.

Create database manually

When installing Connect, if you provide superuser credentials the database is created automatically by the installer.

If you want to manually create a PostgreSQL database that is compatible with Connect, execute the following SQL queries:

Create a new user which will be used by Connect:

CREATE USER <username>

WITH LOGIN PASSWORD '<password>';
Create the new database:

CREATE DATABASE <databaseName>

WITH OWNER = <username>

ENCODING = 'UTF8'

TEMPLATE = 'template0';
Connect to the created database with the new user.
Create the new schema:

CREATE SCHEMA IF NOT EXISTS <schemaName>

AUTHORIZATION <username>;

SSL configuration

To configure SSL, follow instructions on enabling SSL for PostgreSQL in the official PostgreSQL documentation.