...
- You should set the FD_ADMIN password before running the scripts.
- Open the file <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.
- 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.
- 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)
- 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.
...
- Install PosgreSQL.
- Create flexdeploy database
- 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 C:\downloads\Tomcat_Complete-5.1.0.0<Unzip Folder>\database\postgres\install
- /path/to/psql -U postgres -hhostname -p5432 -d flexdeploy -a -b -e -f CreateFlexDeploySchemas.sql > PostgresDDL.txt
...
- Install PosgreSQL.
- Create flexdeploy database
- 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 /downloads/Tomcat_Complete-5.1.0.0<Unzip Folder>/database/postgres/install
- C:\path\to\psql -U postgres -hhostname -p5432 -d flexdeploy-a -b -e -f CreateFlexDeploySchemas.sql > PostgresDDL.txt
...