...
| Table of Contents | ||||
|---|---|---|---|---|
|
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.
Normal database backup procedures should be followed outside of the FlexDeploy Application. Backing up of this database is not included in FlexDeploy.
See FlexDeploy System Requirements for details on software and hardware requirements.
Automated Installer Instructions
If you are using the automated installer, install the Postgres binaries, and create a flexdeploy database.
| Code Block | ||
|---|---|---|
| ||
createdb flexdeploy |
or if you have sql access to the postgres database, and don’t have access to run createdb, you can connect to the postgres database and using sql
| Code Block | ||
|---|---|---|
| ||
create database flexdeploy |
Then, go back to the automated installer documentation because the schema creation is automated.
do not follow this guide.
Manual Schema Creation
| Tip |
|---|
You must be in /database/postgres/install folder from extracted zip when executing scripts. |
...
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.
|
...
Open a command prompt or putty window to the <FlexDeploy Unzip Folder>/database/postgres/install folder from extracted zip, launch psql (use full path if not available on PATH environment)
Run as a user like postgres with privileges to create users and schemas within that database. You may be prompted for password, enter password for user (with -U argument) that you use in psql command.
Change the bold text as needed in your environment.
Run the appropriate command below.
Linux
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 | ||
|---|---|---|
| ||
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 | ||
|---|---|---|
| ||
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 |