Installing software needed to work from home in CSE 444

These notes will walk you through installing the programs you need to work from home in CSE 444:

We assume here that you're using Windows. If you're using Mac OS X or Linux, please help us out by contributing notes for your OS.

Please remember that we only support CSE Instructional Lab-supported computers. If you are having trouble getting your assignment running at home, please try running it on a Lab machine.

General notes

Installing Java

Download and install the Java SDK 6, update 17 from Sun.

Installing PostgreSQL and its JDBC driver

Follow these steps:

  1. Download PostgreSQL 8.4.4 for Windows.
  2. Install it with the default options. The installer will ask you to create a password for the "database superuser and service account." Remember this password; you may need it later.
  3. Then, download the PostgreSQL JDBC driver and save it as C:\Program Files\psqlJDBC\postgresql-8.4-701.jdbc4.jar .
  4. To check that you installed the programs correctly, verify that the files C:\Program Files\PostgreSQL\8.4\bin\psql.exe and C:\Program Files\psqlJDBC\postgresql-8.4-701.jdbc4.jar exist.

Installing the JDBC drivers for SQL Server

To install the SQL Server JDBC driver, download it from here, and save it as C:\Program Files\Microsoft SQL Server 2008 JDBC Driver\sqljdbc4.jar .

Adapting the PostgreSQL instructions

With two major exceptions, the PostgreSQL instructions for Lab machines still apply to working from home.

The first exception is that you can completely skip the sections titled "Creating a data folder" and "Starting and stopping PostgreSQL". The installer already created a data folder, so you don't need to create one yourself, and it set up PostgreSQL to start and shut down along with the computer, so you don't need to start it explicitly.

The second exception is the way you log in to the database system. On Lab machines (when following the suggested procedure for creating a data folder), you are not normally asked for a username or password when connecting to the database. This is because your PostgreSQL username is the same as your Windows username (the default username for PostgreSQL client tools and libraries), and PostgreSQL automatically trusts all connections from the local computer, so any local user can connect using any PostgreSQL username without providing a password.

By default, however, PostgreSQL installed using the Windows installer will prompt you for a username and password; you will need to use postgres for the username and the "database superuser password" you previously set for the password. There are two ways to work around this problem: