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
su - postgres
- Run the
psqlcommand 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 like
raas_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.