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.
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.
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.
Additional Information
Feedback
Yes
No
Powered by
