Creating a PostgreSQL Database for the Catalog User
- Procedure
- Open
$OPE_HOME/database-scripts/postgreSQL/catalog/bin/postgres_catalog_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_USER_NAME
PostgreSQL superuser name PG_SUPER_USER_PASSWORD
PostgreSQL superuser password PG_SUPER_USER_DATABASE
PostgreSQL superuser database PG_CATALOG_USER
New Catalog user PG_CATALOG_PASSWORD
Password for the Catalog user PG_CATALOG_DATABASE
Catalog database name PG_CATALOG_SCHEMA
Catalog schema PG_CATALOG_TABLESPACE
Catalog tablespace PG_CATALOG_TABLESPACE_LOCATION
Catalog 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
catalog_ds_ddl.sql 5.1.0_TO_6.0.0HF0_SCRIPTS
upgrade_5.1.0_to_6.0_ddl.sql
- Save and close the file.
- Run the
$OPE_HOME/database-scripts/postgreSQL/catalog/bin/db-setup.sh
script.