CS 486/586
Introduction to Database Systems
Accounts
Postgres accounts: We will be issuing each student
a Postgres database account.
Unix accounts: If you want to use the
command-line interface or VPN to MCECS, you will need an MCECS account to log in
on one of the various Linux servers such as linux.cs.pdx.edu. If
you don't already have an account, go to https://cat.pdx.edu/users/getting-help/for-new-students/
and see the information about accounts. You can go to the CAT front desks in
person to activate your account and get your password, or use the CAT Remote
Account Manager: https://intranet.cecs.pdx.edu/cram/.
Sample Database
Note: This command file might
change to correct some problems with special characters.
A text file of commands to create the database in PostgreSQL (If you have your
own installation of Postgre, run "psql -e < spy.sql" from
your shell): Spy . You may need to customize null values.
How to Access the sample database on
PostgreSQL
You can
access an installation of PostgreSQL via a command line or GUI interface (phpPgAdmin). Both are explained on https://cat.pdx.edu/services/web/databases/postgres/
.
- From any cat-managed
machine (such as linux.cs.pdx.edu), get to the postgres
command line interface with
%
psql –h dbclass.cs.pdx.edu –U <user>
<user>
and use your Postgres
password.
Alternatively,
- Access the GUI from any
browser via https://dbclass.cs.pdx.edu/.
(You must be on an MCECS machine or connected to MCECS via VPN: https://cat.pdx.edu/services/network/vpn-services/
)
- Click on the Database Class
instance in the left pane to get a login prompt.
- Enter your Postgres username and password.
- To get past the first page of
the GUI, click on the name of the database you want to access.
Other Example
Databases
Your personal database
Click on the Account tab and
change your password in phpPgAdmin, or use the
\password command in the command-line interface. Note: Once you change your
password, you will need to log in again when you next want to do something on
the site.
Your database should have four
schemas in it: spy, store and sailors, plus a schema that has the same name as
your Postgres user name that is initially empty, and
which you can for assignments that require creating tables.