Properties for PostgreSQL

You need to set the following properties in install.xml for a PostgreSQL database:

Property	Description

Property	Description
install.pg.owner	Default value: `mzowner` 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. This property also use as database schema. Note! The installation fails if the same username is configured for both the database owner, `install.pg.owner`, and the `mz.jdbc.user`.
install.pg.password	Default value: `mz` This property specifies the password for the database owner, defined with the `install.pg.owner` variable described above.
install.pg.db.name	Default value: `mz` This property specifies the name of the PostgreSQL database name. Note! The name has to be stated in lower case since PostgreSQL does not support names in upper case.
install.pg.host	Default value: `127.0.0.1` This property specifies IP address or hostname of the database instance.
install.pg.port	Default value: `5432` This property specifies the PostgreSQL database port.
install.pg.tb.space.tab	Default value: `pg_default` This property specifies the name of the tablespace to use to create the table in.
install.pg.tb.space.idx	Default value: `pg_default` This property specifies the name of the tablespace to use for the index.