Page Comparison

...

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.
• 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.

...