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:

1. Become the postgres user using su - postgres
2. Run the psql command to start an interactive database session.
3. 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.