PlateSpin Transformation Manager automatically pre-installs the PostgreSQL database on the appliance. You can alternatively set up the PlateSpin Transformation Manager database as a database instance on an existing PostgreSQL database in your network. The minimum requirements for the PTM database are described in Table 1-5.
Table 1-5 PostgreSQL Database Requirements
|
Parameter |
Local (Default) |
Remote |
|---|---|---|
|
Database Host |
localhost |
Specify the DNS name or IP address of the host server for the remote PostgreSQL database. |
|
Database Port |
5432 |
5432 (or your custom port) |
|
Database administrator credentials |
Automatically creates a PostgreSQL database administrator user and password |
Specify the credentials of the database administrator user who has the schema rights necessary to create a new database instance for PTM and to create a new administrator user account for the new instance. |
|
Create a New Database |
Selected |
Selected |
|
Database Name |
transmgr |
transmgr (or specify a custom name for the PTM database instance) |
|
Database User Name |
tmadmin |
tmadmin (or specify a custom user name and password for the database administrator user account that will be created for the new PTM database instance) |