Page Comparison

...

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.

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

   

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

   $ source ./postgre_create_instance.sh

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

   Tip
   title 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.

      

3. If the script fails: 
   
   Cleanup the system before the next try:
• Start PSQL:
  $ psql
• Remove the Database and Users:
  postgres=# DROP DATABASE mz;
postgres=# DROP USER mzowner;
postgres=# DROP USER mzadmin;
postgres=# \q


...