PostgreSQL Database Creation

The creation of the database must be made by the postgres UNIX user, or another UNIX user with the same privileges, on the machine where PostgreSQL is installed. The postgres UNIX user is assumed in this installation.

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 has been configured, 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 occurred, the database creation will now be completed and the rest of this section can be ignored.

   Hint!

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

      

4. 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 Generation of PostgreSQL Database Definition Files above.