SSH Postgre - notes PDF

Preview

Summary

notes...

Description

How to SSH and Use PostGRE in WCH PC 1. Copy all the necessary files (in zip format) from local PC to bolt account: scp [email protected]:~ means the absolute path of the zip file 2. SSH into bolt account and enter your password: ssh [email protected] where netid is your UCR net id. 3. Confirm that the file is successfully copied using ls command 4. SSH into WCH lab PC using: ssh means the lab PC that you have been assigned. 5. Copy the zip file from bolt account to WCH lab PC: scp [email protected]:~/lab9.zip netid@:~ 6. Unzip using: unzip lab9.zip 7. Go into lab9 folder using: cd lab9/ 8. Start the Postgre server: source ./startPostgreSQL.sh 9. Create the DB: source ./createPostgreDB.sh 10. (For Lab 9-10) Copy the data in text files to the database (this mimics the INSERT statement): cp ∗. txt /tmp//myDB/data/

11. Execute the create table statements from chapter 5 in book: psql −h localhost −p 1024 netid_DB < chapter5.sql 12. Run all the necessary queries 13. STOP THE POSTGRE SERVER using: source ./stopPostgreDB.sh...