...
- You should set the FD_ADMIN password before running the scripts.
- Open the file /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 /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.
| Tip |
|---|
You should record the FD_ADMIN password, which you modified in CreateSchemas.sql file. |
Linux
- 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\database\postgres\install
- /path/to/psql -U postgres -hhostname -p5432 -d flexdeploy -a -b -e -f CreateFlexDeploySchemas.sql >
- PostgresDDL.txt
Windows
...
- 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/database/postgres/install
- C:\path\to\psql -U postgres -hhostname -p5432 -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.
The creation will take a few moments. Then you are ready to connect to the database.
...
- PostgresDDL.txt