Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
weatherbox:database:postgres [2017/09/27 01:14] kcho created |
weatherbox:database:postgres [2021/09/19 21:59] (current) |
||
|---|---|---|---|
| Line 7: | Line 7: | ||
| password is the lab computer password. | password is the lab computer password. | ||
| + | |||
| + | The postgres super user of the psql server has the following login credentials: | ||
| + | |||
| + | user: postgres | ||
| + | |||
| + | password: lab computer password | ||
| + | |||
| + | |||
| + | The only user that has super user access on the lab computer's postgreSQL database. In order to allow the API to connect to the database and have read/write permissions, the postgres user must be used. As such, the credentials saved on the computer use postgres with the password lists above. | ||
| + | |||
| + | Postgres user hosts all the tables for the weather boxes in the lab. To see the tables run the command \dt to show all database tables. | ||
| + | |||
| + | To get to the example bears api table use the following commands after logging in as any user. | ||
| + | |||
| + | \c bears; | ||
| + | |||
| + | SELECT * FROM BEARS; | ||
| + | |||
| + | ====== Things to do ====== | ||
| + | |||
| + | * Need to figure out permissions to each table for each users. (kluong, control_tower, postgres) | ||
| - | The control_tower user hosts all the tables for the weather boxes in the lab. To see the tables run the command \dt to show all database tables. | ||