Versions Compared

Old Version 1

changes.mady.by.user Yeok Hong Ng (Deactivated)

Saved on

compared with

New Version Current

changes.mady.by.user Chee Hove Teng

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

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

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

schema

name.

Note

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.