Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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. 
  • weatherbox/database/postgres.1506474899.txt.gz
  • Last modified: 2021/09/19 21:59
  • (external edit)