Versions Compared

Old Version 15

changes.mady.by.user Chandresh Patel

Saved on

compared with

New Version Current

changes.mady.by.user Chandresh Patel

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

FlexDeploy uses three schemas (FD, FF, and FD_ADMIN) in the database and performs all work using the FD_ADMIN user. 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 <Unzip <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.

...

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.

Tip

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.

  1. Modify commands below appropriately for different database name.
  2. Modify <FlexDeploy Unzip Folder>/database/postgres/install/scripts/CreateSchemas.sql, statement "GRANT CONNCET ON DATABASE flexdeploy TO FD_ADMIN;" should be modified for proper database name.
  3. Adjust JDBC URL in context.xml appropriately.

These are high level steps, you can find more detailed steps in PostgreSQL documentation.

Code Block
languagepowershellbash
themeRDark
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

...

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

...

  • 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 <Flexdeploy Unzip Folder>\database\postgres\install
    • /path/to/psql -U postgres -h hostname -p 5432 -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 -h hostname -p 5432 -d flexdeploy -a -b -e -f CreateFlexDeploySchemas.sql > PostgresDDL.txt