Access your PostgreSQL database at IU RDC

On this page:

PostgreSQL clients
Connect to PostgreSQL using psql
Connect to PostgreSQL using pgAdmin
Get help

PostgreSQL clients

Note:

The Indiana University Research Database Complex (RDC) supports research-related MySQL and PostgreSQL databases and data-intensive applications that require databases. The RDC is strictly devoted to supporting research, and is not an instructional, classroom environment.

To connect to your PostgreSQL account on the RDC, use one of the following:

PostgreSQL command-line client: psql, a PostgreSQL command-line client, is available on Quartz.
pgAdmin: The pgAdmin graphical client is available for free download from PostgreSQL. To find the correct version for your OS, go to Download pgAdmin.

Connect to PostgreSQL using psql

Note:

When you requested the creation of your RDC PostgreSQL database, you received information that you need to connect to your database:

Your PostgreSQL database login (_root username)
Information about your initial database password
Your database host and port number

If you no longer have this information, email the RDC Administration group (rdcadmin@iu.edu) for help.

If you are off campus, make sure you're using IU VPN.

To request an account on an Indiana University research system, see Get additional IU computing accounts. Account availability depends on your eligibility.

If you have an account on Quartz, you can use psql to access your MySQL database:

Load the postgresql module; on the command line, enter:
```
module load postgresql
```
On the command line, enter (replace username_root with your PostgreSQL database login):
```
psql -h sasrdspp01.uits.iu.edu -p 5444 -d group_account -U username_root
```
Note:

For security reasons, do not enter your password on the command line.
When prompted, enter your PostgreSQL database password.
When you log in successfully, you will be placed at your database prompt (group_account=>).

Connect to PostgreSQL using pgAdmin

Open pgAdmin. On the home screen, select File > Register > Server.
In the "Register - Server" window:
1. Enter your database credentials.
2. In the General tab, enter a descriptive name, such as the account name used for the database account.
3. In the Connection tab, for "Host name/address", enter the RDC PostgreSQL hostname sasrdspp01.uits.iu.edu; for the port, enter 5444.
4. For "Maintenance database", enter your group account name.
5. For "Username", enter your PostgreSQL database login (username_root) sent to you.
6. For "Password", use the password sent with your username. UITS does not recommend storing the password in the vault.
To test your credentials, in the bottom of the window, select Save. If the connection is successful, it will be saved.

Get help

For help connecting to your PostgreSQL database, email the RDC Administration team (rdcadmin@iu.edu).