ImageMaster supports PostgreSQL, often simply called “Postgres”, as its database. For details on the exact versions of PostgreSQL that have been approved with ImageMaster, see the ImageMaster compatibility guide [T Compatibility Guide]. This document describes an exemplified installation of PostgreSQL including the setup of a database with an ImageMaster 9 database model.
Focus is put on an installation for Red Hat Enterprise Linux, which corresponds to an installation on CentOS. It is assumed that the target system can connect to the Internet, so the required software can be downloaded with YUM, a widely used command-line package-management utility for computers running the Linux operating system using the RPM Package Manager. The installation is characterized by the following steps:
-
installation of the PostgreSQL software with YUM
-
creation of a database cluster
-
creation of a dedicated database with a configuration suited for ImageMaster
-
creation of the ImageMaster database model
The ImageMaster assembly release contains a subfolder “db-model” which includes scripts for the creation of the ImageMaster database model. The scripts are packaged into a ZIP file, e.g. ima-db-model-9.x.1.1.zip with subfolders for dedicated database types.
The following sources provide further information and documentation about PostgreSQL:
-
The PostgreSQL home page [PgSQL Home] contains a download area [PgSQL Download].
-
EnterpriseDB [PgSQL EDB Home] provides an interactive installer [PgSQL EDB Installer].
Using the interactive installer is recommended only on Windows and a package-management utility is preferred on Linux systems.
Start with an unmodified installation and follow these steps according to chapter Installation of PostgreSQL.
The installation description within this manual assumes that the database is owned by the specific ImageMaster database user.