Accessing the SSE postgres database
Applicable versions: SSE 6.0.1, 6.1.0, 6.2.0
At times, it may be necessary to connect to the SSE database in order to respond to a Support request for diagnostic information, or to run a recipe recommended by Support or a Knowledge Base article.
To connect to the database from the command line from a database server, use the following steps:
- Become the
postgres
user usingsu - postgres
- Run the
psql
command to start an interactive database session. - Connect to the RaaS database using tab completion to get the database name:
\c raas_<TAB>
This should complete to a name likeraas_43cab1f4de604ab185b51d883c5c5d09
, and you will see a message:You are now connected to database "raas_43cab1f4de604ab185b51d883c5c5d09" as user "postgres".
You should now be able to run queries against SSE's RaaS database.