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
-
Open the
postgres_shoppingcart_db.propertiesfile 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 |
-
Save and close the file.
-
Run the
db-setup.shscript.