Server Information
CS422, Summer 2004
The server we will be using for this class is cs.calstatela.edu, which
has Redhat Enterprise V 3.0 AS installed. Thirty student account have
been created,
with user names cs422stu01, cs422stu02, cs422stu03, ..., cs422stu30. Each account also comes
with a PostgreSQL database, and a PostgreSQL account with the same user
name and password. Each
student enrolled in the class will be assigned one of these accounts.
[Server Access]
The server supports remote access through SecureShell (SSH). To access
the server, it
is recommended that you use the non-commercial version of SSH
Secure Shell for Workstations, which can be downloaded from http://www.ssh.com/support/downloads/secureshellwks/non-commercial.html
free of charge. This is the same SSH
software
installed on the lab machines, and it includes both a Secure
Shell client which can be used to log on to the server, and a Secure
File Transfer client which can be used to transfer files to and from
the server. Note that Telnet and FTP are NOT supported.
[Database Access]
To access the PostgreSQL database, you may want to use either the
command line client psql, which comes with the official
PostgreSQL distribution, or some GUI client such
as pgAdmin III. The general
syntax for psql is psql -h hostname -d dbname -U username,
e.g. psql -h cs.calstatela.edu -d cs422stu31 -U cs422stu31.
Note that
- the database name is the same as the user name, and
- if you are already logged on to cs.calstatela.edu, you may omit
the -h, -d, and -U options and simply use psql.