This page provides the system requirements and installation instructions for the FlexDeploy database tier on PostgreSQL.
...
| Table of Contents |
|---|
...
|
...
|
Requirements
See FlexDeploy System Requirements for details on software and hardware requirements.
Automated Installer Instructions
If you are using the automated installer, do not follow this guide.
Manual Schema Creation
| Tip |
|---|
You must be in /database/postgres/install folder from extracted zip when executing scripts. |
FlexDeploy uses three
...
schemas (FD, FF, and FD_ADMIN) in the database and performs all work using the FD_ADMIN user.
...
Installation Instructions
Run database scripts from where you extracted downloaded FlexDeploy zip file. Navigate to the /database/postgres/install directory.
...
Step 1. You should set the FD_ADMIN password before running the 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.
| Info |
|---|
You should record the FD_ADMIN password, as that will be used in configuration of data source on application server. |
Step 2. Install PostgreSQL database, if you have not done that already. Follow guidelines for your platform as documented in PostgreSQL documentation.
Step 3. Create flexdeploy database.
| Info |
|---|
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.
|
These are high level steps, you can find more detailed steps in PostgreSQL documentation.
| Code Block | ||
|---|---|---|
| ||
cd <PosgreSQL Install Home>\pgsql\bin
initdb.exe -D <Data Folder> --username=postgres --auth=trust
pg_ctl -D ../data -l logfile start
pg_ctl start -l <Data Folder>\server.log -D <Data Folder>
createdb flexdeploy |
Step 4. Create FlexDeploy schema objects.
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
.
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 |
...
WINDOWS
> 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 > |
...
Type the password when asked.
> postgresDDL.txt records the output of the script so that you can refer back to it later.
...
PostgresDDL.txt |