This is an old revision of the document!
Table of Contents
Database Access (Undergrad)
A Postgres database is available for EECS courses requiring database use. Faculty who want to use the database in their course can send a request to tech including the respective course and section numbers. The tech team will create a database for each student in each course.
Access Database By CLI
In order to access the database by command line, students can issue the “psql” command from any EECS tech-supported Linux system. Students must be enrolled in a course that has requested database access. The student will be logged into Postgres, and connected to a database that has the same name as their EECS username.
Access The Database By GUI
An enterprise database GUI called DBeaver Enterprise is available for students to access the database. Students will need to complete the steps below one time:
- From the Linux terminal, type “id -u”. You will get back a number. Record that number.
- Start DBeaver with the “dbeaver” command.
- When DBeaver starts, you will be prompted: “Do you want to create sample database? It can be used as an example to explore basic DBeaver Enterprise features”. You can select Yes/No.
- From the “File” menu, choose “New”, then open “DBeaver” folder, then select “Database Connection”.
- Click Next >
- Select “PostgresSQL” from the list of available databases.
- Click Next >
- In the “Connect to a database” window, change:
- Hostname: db.eecs.yorku.ca
- Database: <specify your username>
- Authentication: change to “PostgreSQL Kerberos”
- Username: <your EECS username>
- Kerberos user: leave default value
- Realm: leave default value
- KDC server: leave default value
- Password: <enter your EECS password>
- Next, click on “Extra Configuration” which opens up a few options.
- Check off: “Use kinit” and specify: /tmp/krb5cc_<uid> where <uid> is the number you recorded in the first step.
- Click “Finish”.
- Under “Database Navigator” tab, you will see: “<your EECS-username> - db.eecs.yorku.ca:5432”
- Open this up, and you will be connected to your personal database.
First time connection is a little challenging, and requires the following steps: