How to expose details from a Postgres startup failure?
book
Article ID: KB0077072
calendar_today
Updated On:
Products
Versions
TIBCO Data Virtualization
All supported versions
Description
Scenario: The Postgres service will not start. This may be concluded either from witnessing a startup failure from a console, or in the TDV server log's failed bootup routine that shows that the server was unable to connect to an active Repository service.
Issue/Introduction
This concerns the use of TIBCO Data Virtualization's (TDV) Postgres meta-db platform (aka the Repository).
Resolution
If there is nothing logged in our /logs/cs_repository-<day of the week>.log, you can then attempt to start the Postgres service from the command line.
Run this command to start Postgres in a foreground mode: <install dir>/repository/bin/postgres -D <path of TDV install dir>/repository/data
Any systemic issues can potentially be displayed in this foreground session. A successful start will simply leave the cursor hanging in the foreground, requiring you to use a "Ctrl-C" (Control-c)to stop the running Postgres processes.