Error while executing the 'postgres_install' script for the creation of the TIBCO Spotfire database.
book
Article ID: KB0075462
calendar_today
Updated On:
Description
After configuring the required parameters in the 'postgres_install' database script, it throws below error message in the 'logs.txt' file:
==============================
psql: error: could not connect to server: FATAL: password authentication failed for user "SERVERDB_USER_1090"
==============================
Note: Where "SERVERDB_USER_1090" is the server database username value specified in the 'SERVERDB_USER' parameter.
Environment
All Supported OS
Resolution
The root cause of the above error message is that the username specified in the 'set SERVERDB_USER' line/code of the script is having UPPER case character(s). So, SERVERDB_USER value should always be in lower case character(s).
Issue/Introduction
Error while executing the 'postgres_install' script for the creation of the TIBCO Spotfire database.
Feedback
thumb_up
Yes
thumb_down
No