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.

Issue/Introduction

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

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).
Powered by Wolken Software