Versions Compared

Old Version 1

changes.mady.by.user Yeok Hong Ng

Saved on

compared with

New Version Current

changes.mady.by.user Jenni Wallin

Saved on

Key

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

...

  1. Configure the PostgreSQL database to allow a remote client connection to the database. The working directory is $PGDATA.

    Edit the pg_hba.conf file to match the settings in install.xml.
    See Appendix D - PostgreSQL HBA Settings for an example.

  2. When the files have been configured, the PostgreSQL database needs to be restarted.

  3. Create the PostgreSQL database instance. The working directory is postgres.

    $ source ./postgre_create_instance.sh

    If no error occurs, the database creation is complete and the rest of this section can be ignored.

Tip

Hint!

When the instance creation script is executed, a log file in the /tmp directory is created that can be used for troubleshooting. The mz.log file contains PostgreSQL responses from the database creation.

...

 

  1. If the script fails, cleanup the system before the next try:

    1. Start PSQL:
      $ psql

    2. Remove the Database and Users:
      postgres=# DROP DATABASE mz;
      postgres=# DROP USER mzowner;
      postgres=# DROP USER mzadmin;
      postgres=# \q

If there is a need to change any installation parameter defined in the file install.xml, the installation must be restarted from the generation step. For further information, see Extract Database Definition Files for PostgreSQL.

...