Page Comparison

...

• 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.
• Change the bold text as needed in your environment.
• Run the appropriate command below.

1. You should set the FD_ADMIN password before running the scripts.
2. Open the file <Unzip Folder>/database/postgres/install/scripts/CreateSchemas.sql
   1. Edit the line: CREATE USER FD_ADMIN with password 'welcome1'; so that it has a new password in it.
3. Create a new PostgreSQL Database named flexdeploy (you could also use another database and then change the line "GRANT CONNECT ON DATABASE flexdeploy TO FD_ADMIN;" to have a different database granted.
4. Open a command prompt or putty window to the <Unzip Folder>/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 schemas within that database.
6. Change the bold text as needed in your environment.
7. 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.
  • cd <Unzip <Flexdeploy Unzip Folder>\database\postgres\install
  • /path/to/psql -U postgres -hhostname -p5432 -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. 
  • cd <Unzip Folder>/database/postgres/install
  • C:\path\to\psql -U postgres -hhostname -p5432 -d flexdeploy-a -b -e -f CreateFlexDeploySchemas.sql > PostgresDDL.txt