Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table of Contents
minLevel1
maxLevel7

Requirements

...

PostgreSQL 11,12,13,14

...

4GB of RAM

...

1+ CPU

...

At least 10GB of available space, may need additional space. Purge settings within FlexDeploy will determine future needs.

...

See FlexDeploy System Requirements for details on software and hardware requirements.

Automated Installer Instructions

If you are using the automated installer, don’t use do not follow this guide.

Manual Schema Creation

...

  • Open the file <FlexDeploy Unzip Folder>/database/postgres/install/scripts/CreateSchemas.sql

  • Edit the line: CREATE USER FD_ADMIN with password 'welcome1'; so that it has a new password in it.

Tipinfo

You should record the FD_ADMIN password, as that will be used in configuration of data source on application server.

...

Step 3. Create flexdeploy database.

Tipinfo

Database name is setup as flexdeploy various documentation steps, you are free to use different name. If you use database name other than flexdeploy, then consider following points.

  1. Modify commands below appropriately for different database name.

  2. Modify <FlexDeploy Unzip Folder>/database/postgres/install/scripts/CreateSchemas.sql, statement "GRANT CONNECT ON DATABASE flexdeploy TO FD_ADMIN;" should be modified for proper database name.

  3. Adjust JDBC URL in context.xml appropriately during application installation.

...

  • Run FlexDeploy scripts. Type the password when asked. PostgresDDL.txt records the output of the script so that you can refer back to it later.

Code Block
languagebash
cd <Flexdeploy Unzip Folder>\database\postgres\install

...


/path/to/psql -U postgres -h hostname -p 5432 -d flexdeploy -a -b -e -f CreateFlexDeploySchemas.sql > PostgresDDL.txt

Windows

  • Run FlexDeploy scripts. Type the password when asked. PostgresDDL.txt records the output of the script so that you can refer back to it later. 

Code Block
languagebash
cd <Unzip Folder>/database/postgres/install

...


C:\path\to\psql -U postgres -h hostname -p 5432 -d flexdeploy -a -b -e -f CreateFlexDeploySchemas.sql > PostgresDDL.txt