Error while executing the 'postgres_install' script for the creation of the TIBCO Spotfire database.

Error while executing the 'postgres_install' script for the creation of the TIBCO Spotfire database.

book

Article ID: KB0075462

calendar_today

Updated On:

Products Versions
Spotfire Server 10.9

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.