By default, the following roles are set up in PostgreSQL and for security are stored in the PASSWORDS Configuration.
|postgres||postgres||used to access the PostgreSQL database|
|prognosis||prognosis||used to access the PostgreSQL database|
|replication||replication||used for HA replication|
These roles will initially be set up with default passwords during installation. As PostgreSQL is included with the installation on each MS Windows machine, it is recommended to change these passwords on all installations in order to increase security.
The usernames (match to the Roles) for these password entries cannot be changed.
When the password is changed on the PostgreSQL instance, the PASSWORDS Configuration must also be updated so that internal connections will be successful.
The PASSWORDS Configuration can be updated by using the Updating the PASSWORDS Configuration procedure.
PostgreSQL specific PASSWORD Entries
* These usernames cannot be changed
The 'sfbuser' user password is not configurable using the PASSWORDS Configuration, see PostgreSQL Password Configuration