Database Account Related Issues
The table below outlines most common errors when adding database accounts, along with their recommended solutions.
Issue | Error Code in Logs | Description and Possible Solution |
|---|---|---|
Unable to add account | Error: FATAL: password authentication failed for user XXX | Check user credentials |
Unable to add account | Error: Connection to XXX refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. | Check network connection to target device |
Unable to add account | Error: ERROR: syntax error at or near "XXX" Position: 29 | Check password vault configuration |
Unable to check new users | New users could not be detected. Please check the configuration. ERROR: relation "XXX" does not exist Position: 21. | Check password vault configuration |