Authentication method and password settings of PostgreSQL (in Linux)

1. Stop Manager service

For details about how to stop Manager service, see Stopping Manager (in Linux).

2. Stop PostgreSQL service

For details about how to stop PostgreSQL service, see Stopping PostgreSQL (in Linux).

3. Change the PostgreSQL authentication method

The PostgreSQL authentication method is set to "trust" and no password is set to be used just after Manager is installed. Change the authentication method to a method other than "trust".

Settings file

/opt/hulftiot-manager/manager/postgresql/data/pg_hba.conf

Setting value (recommended)

md5 (use an encrypted password)

4. Set the password for the database user named "postgres"

Set a password according to the authentication method changed in step 3.

For details about how to change the password with PostgreSQL, see the PostgreSQL website.

5. Revise the environment settings file of Manager

Specify the password that was set in step 4 for spring.datasource.password in the environment settings file of Manager (application.properties).

For details about an environment settings file storage directory, see Table 2.2 Server configuration after an installation (in Linux).

6. Start PostgreSQL service

For details about how to start PostgreSQL service, see Starting PostgreSQL (in Linux).

7. Start Manager service

For details about how to start Manager service, see Starting Manager (in Linux).