HCL Commerce Version 9.1.12.0 or later

Starting the PostgreSQL Docker container with default configurations

Learn how to start the PostgreSQL Docker container.

To start the container with default configurations to view files inside the container, use:
docker run -it -e LICENSE=accept postgres
When you start by using the default configurations, the PostgreSQL Docker container Docker image name is postgres.

Default host name

When you start by using the default configurations, the PostgreSQL Docker container  host name is postgresql.

Mandatory parameters

Parameter name Value
SPIUSER_PWD The encrypted password for the spiuser. For more information, see Setting the spiuser password in your Docker images.
AUTH_TOOLING_HOST The Authoring environment tooling web hostname.
LIVE_TOOLING_HOST The Live environment tooling web hostname.
SESSION_KEY_ENCRYPT The encrypted session key.
Note: This parameter was optional in all releases prior to HCL Commerce 9.1.12.0.

app-secure.properties

A boot configuration file, app-secure.properties, is also required to be passed in by volume to initialize some database configurations in order to connect to PostgreSQL. The contents of this configuration file depend on whether or not you want to enable secure SSL connectivity to the database.

  • For an SSL enabled database:
    spring.datasource.url=jdbc:postgresql://postgresql:5432/comdb?ssl=true&sslfactory=org.postgresql.ssl.DefaultJavaSSLFactory spring.datasource.username=hclcom  
    spring.datasource.password=user-password 
    spring.datasource.hikari.schema=hclcom spring.flyway.url=jdbc:postgresql://postgresql:5432/comdb?ssl=true&sslfactory=org.postgresql.ssl.DefaultJavaSSLFactory  
    spring.flyway.user=hclcom  
    spring.flyway.password=user-password 
    spring.flyway.default-schema=hclcom
  • For a non-SSL enabled database:
    spring.datasource.url=jdbc:postgresql://postgresql:5432/comdb spring.datasource.username=hclcom
    spring.datasource.password=user-password
    spring.datasource.hikari.schema=hclcom spring.flyway.url=jdbc:postgresql://postgresql:5432/comdb
    spring.flyway.user=hclcom
    spring.flyway.password=user-password
    spring.flyway.default-schema=hclcom

Optional parameters

Parameter name Description
SPIUSER_NAME The SPIUSER name. If it is not specified, then the default value spiuser is assumed.
AUTH_TOOLING_PORT The Authoring environment tooling web port. If it is not specified, then the default value 8000 is assumed.
LIVE_TOOLING_PORT The Live environment tooling web port. If it is not specified, then the default value 8000 is assumed.