This page provides the system requirements and installation instructions for the FlexDeploy database tier on PostgreSQL.

Requirements

• 4GB of RAM
• 1 or 2 CPU
• At least 10GB of available space, may need additional space. Purge settings within FlexDeploy will determine future needs.
• Normal database backup procedures should be followed outside of the FlexDeploy Application. Backing up of this database is not included in FlexDeploy.
• FlexDeploy uses three databases (FD, FF, and FD_ADMIN) and performs all work using the FD_ADMIN user.

Installation Instructions

1. You should set the FD_ADMIN password before running the scripts.
2. Open the file /database/postgres/install/scripts/Create Schemas.sql
3. Edit the line: CREATE USER FD_ADMIN with password 'welcome1'; so that it has a new password in it.
4. Open a command prompt or putty window to the /database/postgres/install folder from extracted zip, launch psql(use full path if not available on PATH environment)
5. Run as a user like postgres with privileges to create users and objects within those schema users
6. Change the bold text as needed in your environment.
7. Run the appropriate command below.

LINUX

/path/to/psql -U postgres -hhostname -p5432 -d postgres -a -b -e -f CreateFlexDeploySchemas.sql > postgresDDL.txt

WINDOWS

C:\path\to\psql -U postgres -hhostname -p5432 -d postgres -a -b -e -f CreateFlexDeploySchemas.sql > postgresDDL.txt

Type the password when asked.

> postgresDDL.txt records the output of the script so that you can refer back to it later.

The creation will take a few moments. Then you are ready to connect your datasource to the database.

You should record the FD_ADMIN password. Then you may wish to delete the Create Schemas.sql file.