- Start pgAdmin4.exe from <FMEServerDir>\Utilities\pgsql\pgAdmin 4\bin\.
- If this is your first time starting pgAdmin4, it will prompt you to set a master password. Choose something you will remember.
- If pgAdmin auto-connects to the FME Server Database, an entry appears in the Object browser, under Servers, similar to the following:
fmeserver (<hostname>:7082)
If pgAdmin III does not auto-connect to the FME Server Database, add a new Server for it. To add a New Server:
- Right-click on Servers and Select Create > Server....
- In the General tab of the Create - Server dialog, specify the Name for the server connection. This can be anything, such as fmeserver.
- In the Connection tab of the Create - Server dialog, specify the server properties, using the Database Connection details in the fmeCommonConfig configuration file, for DB_TYPE=postgresql, as follows:
| Host name/address |
DB_JDBC_URL=jdbc:postgresql://<hostname>:<port>/<database_name> |
| Port |
DB_JDBC_URL=jdbc:postgresql://<hostname>:<port>/<database_name> |
| Maintenance database |
DB_JDBC_URL=jdbc:postgresql://<hostname>:<port>/<database_name> |
| Username |
DB_USERNAME=<username> |
| Password |
DB_PASSWORD=<password> |
- Click Save.
- In the Object browser, select the FME Server Database server, and locate and expand Login/Group Roles.
- Right-click the fmeserver database user account and select Properties. Under Definition, change the Password and click Save.
- In the following configuration files, update the value of the DB_PASSWORD parameter that corresponds to DB_TYPE=postgresql with the new password specified above.
When finished, save both files.
- (Recommended) Encrypt the FME Server Database password.
- Restart FME Server.
