Creating a PostgreSQL Database for the Shopping Cart User

    Procedure
  1. Open $OPE_HOME/database-scripts/postgreSQL/shoppingCart/bin/postgres_shoppingcart_db.properties file in a suitable editor and update the following values:
    Property Update the Value for
    PG_HOME PostgreSQL database home
    PG_HOST PostgreSQL database host
    PG_PORT PostgreSQL port
    PG_SUPER_USERNAME PostgreSQL superuser name
    PG_SUPER_PASSWORD PostgreSQL superuser password
    PG_SUPER_USER_DATABASE PostgreSQL superuser database
    PG_SHOPPINGCART_USER New shopping cart user
    PG_SHOPPINGCART_PASSWORD Password for the shopping cart user
    PG_SHOPPINGCART_DATABASE Shopping cartdatabase name
    PG_SHOPPINGCART_SCHEMA Shopping cartschema
    PG_SHOPPINGCART_TABLESPACE Shopping cart tablespace
    PG_SHOPPINGCART_TABLESPACE_LOCATION Shopping cart tablespace location
    IS_CLOUD_PLATFORM Default value is false. You need to set it to true if the database is on a cloud platform.
    EXECUTE_DDL_DML_ONLY Default value is false. You need to set it to true if you want to execute only DDL/DML.
    BASE_INSTALLATION_SCRIPTS shoppingcart_ds_ddl.sql
  2. Save and close the file.
  3. Run the $OPE_HOME/database-scripts/postgreSQL/shoppingCart/bin/db-setup.sh script.