Creating a PostgreSQL Database for the Shopping Cart User
- Procedure
- Open
$OPE_HOME/database-scripts/postgreSQL/shoppingCart/bin/postgres_shoppingcart_db.propertiesfile in a suitable editor and update the following values:Property Update the Value for PG_HOMEPostgreSQL database home PG_HOSTPostgreSQL database host PG_PORTPostgreSQL port PG_SUPER_USERNAMEPostgreSQL superuser name PG_SUPER_PASSWORDPostgreSQL superuser password PG_SUPER_USER_DATABASEPostgreSQL superuser database PG_SHOPPINGCART_USERNew shopping cart user PG_SHOPPINGCART_PASSWORDPassword for the shopping cart user PG_SHOPPINGCART_DATABASEShopping cartdatabase name PG_SHOPPINGCART_SCHEMAShopping cartschema PG_SHOPPINGCART_TABLESPACEShopping cart tablespace PG_SHOPPINGCART_TABLESPACE_LOCATIONShopping cart tablespace location IS_CLOUD_PLATFORMDefault value is false. You need to set it to true if the database is on a cloud platform. EXECUTE_DDL_DML_ONLYDefault value is false. You need to set it to true if you want to execute only DDL/DML. BASE_INSTALLATION_SCRIPTSshoppingcart_ds_ddl.sql - Save and close the file.
- Run the
$OPE_HOME/database-scripts/postgreSQL/shoppingCart/bin/db-setup.shscript.