Error message: 'Database does not exist' gets logged to the 'logs.txt' file while executing the 'postgres_install' script for the creation of the TIBCO Spotfire database.
Article ID: KB0075407
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | 10.9 |
Description
From TIBCO Spotfire 10.9 version, 'PostgreSQL' can be used to configure Spotfire metadatabase. 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: database "SPOTFIRE_server_9" does not exist
=========================
Note: Where "SPOTFIRE_server_9" is the server database name value specified in the 'SERVERDB_NAME' parameter.
=========================
psql: error: could not connect to server: FATAL: database "SPOTFIRE_server_9" does not exist
=========================
Note: Where "SPOTFIRE_server_9" is the server database name value specified in the 'SERVERDB_NAME' parameter.
Issue/Introduction
Error message: 'Database does not exist' gets logged to the 'logs.txt' file 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 database name specified in the 'set SERVERDB_NAME' line/code of the script is having UPPER case characters. So, SERVERDB_NAME value should always be in lower case characters.
Note: According to the PostgreSQL standards, it is recommended to use lower case characters for the SERVERDB_NAME parameters.
Note: According to the PostgreSQL standards, it is recommended to use lower case characters for the SERVERDB_NAME parameters.
Additional Information
Feedback
Yes
No
Powered by
