Run
fta-create-postgresql-db
NOTE:
Ensure
that the psql path is set in the
fta-setup-env.cmd
file.
Based on the type of installation and the version being installed,
the paths may vary. For example with PostgreSQL 13: set PSQL="C:\Program Files\PostgreSQL\13\bin\psql.exe"
To use PostgreSQL as the metadata repository
for Security Provider user will need both, an account to use by
the Security Provider and a database called FTASecurity. This script
will create both the user and database.
|
Supported Special
Characters
The following table contains a list of the
supported
special characters that can
be used to create a password for the PostgreSQL user:~ | { | } | [ | ] | ! |
@ | - | _ | $ | * | + |
/ | ? | : | . |
NOTE:
Combinations of 3 supported
special characters in a consecutive pattern may cause unexpected results.
For example: ${}
IMPORTANT:
Ensure
that the arguments with special characters are handled correctly
and the temporary files created by the scripts are cleaned up. Escaping
will be necessary for any of the command arguments with special
characters (e.g. $, !)
In a Windows environment use double quotes
(" ") around strings that utilize special characters. For example
if the PostgreSQL password is Welcome! the command would be:
|
NOTE:
Write down this password
somewhere for future installation steps. Example: Password!
Unsupported Special
Characters
The following table contains a list of the
special characters that are
not supported
to
create a password for the PostgreSQL user:\ | " | & | < | > | | | ' |
` | % | = | ; | ^ | blank | # |
( | ) | , |
Provide Feedback