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. |