Versions Compared

Old Version 1

changes.mady.by.user Yeok Hong Ng

Saved on

compared with

New Version 2

changes.mady.by.user Jenni Wallin

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.

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.

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.