-
Database Type: Select Postgres.
-
Database Server: The hostname or IP address of the database server.
-
Database Name / SID: The name of the database.
-
Username: Provide the user name that j5 should use to connect to the database.
-
Password: The password for the j5 database user specified above.
-
Port (optional): The TCP port to connect to. If this is left blank, it defaults to 5432 (the default PostgreSQL port).
The following needs to be configured on your Postgres database (this is not configured in j5):
-
The default authentication method for Postgres 12 is SCRAM. j5 version 28.0 doesn't support SCRAM. To use Postgres 12 with j5 version 28.0, change the authentication method to MD5.
-
If your j5 system has a large number of concurrent users, in order to use j5 effectively your Postgres database needs to be configured with at least 300 concurrent database connections (max_connections) and 256MB for the shared buffers.