Creating a PostgreSQL Database for the Shopping Cart User

Create a PostgreSQL database for the Shopping Cart User and Default Tenant by configuring and running the following script:
$OPE_HOME/db/database-scripts/postgreSQL/shoppingcart/bin/db-setup.sh

Procedure

1. Open the postgres_shoppingcart_db.properties file in a suitable editor and update the following values in the script:

Property	Value
PG_HOST	PostgreSQL database host
PG_PORT	PostgreSQL port
PG_SUPER_USER_DATABASE	PostgreSQL superuser database
PG_SHOPPINGCART_USER	PostgreSQL shopping cart user
PG_SHOPPINGCART_PASSWORD	PostgreSQL shopping cart password
PG_SHOPPINGCART_DATABASE	PostgreSQL shopping cart database
PG_SHOPPINGCART_SCHEMA	shopping cart schema
PG_SHOPPINGCART_TABLESPACE	shopping cart tablespace
PG_SHOPPINGCART_TABLESPACE_LOCATION	shopping cart tablespace location
IS_CLOUD_PLATFORM	false
EXECUTE_DDL_DML_ONLY	false
PG_HOME	C:/Program Files/PostgreSQL/11/bin

2. Save and close the file.

3. Run the db-setup.sh script.

Top