Properties for PostgreSQL
- Jenni Wallin
- Wei Siong Siow
- Former user (Deleted)
You need to set the following properties in install.xml for a PostgreSQL database:Â
| Property | Description |
|---|---|
install.pg.owner | Default value: This property specifies the PostgreSQL username for the database owner. This user will own all the data definitions in the PostgreSQL instance to be created. Note! The installation fails if the same username is configured for both the database owner and the runtime (jdbc) user, mz.jdbc.user. Â |
install.pg.password | Default value: This property specifies the password for the database owner, defined with the install.pg.owner variable described above. |
install.pg.db.name | Default value: This property specifies the name of the PostgreSQL database schema. Note! The name has to be stated in lower case since PostgreSQL does not support names in upper case. |
install.pg.host | Default value: This property specifies IP address or hostname of the database instance. |
install.pg.port | Default value: This property specifies the PostgreSQL database port. |
| install.pg.tb.space.tab | Default value:Â This property specifies the name of the tablespace to use to create the table in. |
| install.pg.tb.space.idx | Default value:Â This property specifies the name of the tablespace to use for the index. |