Steps:
1. Connect to vCD through ssh as a root
2. Enter the postgresql database command below
- su postgres
- psql
3. you can list the databases to double check Run command "postgres-# \l" --- you are looking for "vcloud"
4. Connect the vcloud database -- Run command "\c vcloud"
5. You can list the tables to see how it’s structured or if you’re looking for something else than our current use case --- Run command "\dt;"
6. To check the specific table run command "select * from failed_cells" or "select * from scheduled_activity_jobs"
7. All done.
Commentaires