...
- Configure the PostgreSQL database to allow a remote client connection to the database. The working directory is $PGDATA
Edit the
When the files has been configured, PostgreSQL database needs to be restartedpg_hba.conf
file to match the settings in install.xml. See Appendix A - PostgreSQL HBA Settings (2.3) for an example..
Create the PostgreSQL database instance. The working directory is postgres.
Code Block $ source ./postgre_create_instance.sh <PostgreSQL Admin username, default is postgres>
If no error occurred, the database creation will now be completed and the rest of this section can be ignored.
Tip title 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. Themz_db.log fil
e
contains PostgreSQL responses from the database creation- 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
...