labs / tiddlers / content / labs / lab03 / _Labs_03_Getting Set

The first task will be to connect to a PostgreSQL database using <> DBMS

DBeaver is a generic database client that allows developers and database administrators to send SQL statements directly to a database. It can be used to create and manage databases on pretty much any relational DBMS.

DBeaver needs to know how to connect to your account on the PostgreSQL server. You should normally only need to do this once. Connections are listed in the <

> panel on the left, but are only stored locally.

  1. The first step is to add the <

    > science menu to the <> menu. Click the following link for instructions on adding this menu:


  2. Start DBeaver using <

    All Programs > Information Science > DBeaver">>.

  3. Once DBeaver is running, create a connection to the database using <

    New Database Connection">> or click the <> icon at top left.

  4. Select PostgreSQL in the list and click <

    > (use the search box if you cannot see it).

  5. Enter the connection settings as shown below:

    {{/Labs/03/Images/Connection Settings}}

    <> The password for your PostgreSQL account is the one that was emailed to you by Mark George, not your normal University password.
  6. You can test the connection before you save it (click <

    >). DBeaver may ask you to download the PostgreSQL JDBC driver. Just click the <> button in the window that appears.

  7. Click <

    > to save the connection.