The standard PostgreSQL installation includes a number of related tools that you'll need, such as pSQL, createdb & pg_restore. These tools are mentioned throughout the documentation provided on this site; they should all be available to you once PostgreSQL is installed.
AACT is currently running on version 9.5.4 of PostgreSQL; it's recommended you install this version or higher. Refer to PostgreSQL Downloads for free software and installation instructions.
Once PostgreSQL is installed on your local machine, you can access pSQL from a terminal session by entering the command: psql. To access the AACT cloud-hosted database, open a terminal window and enter the psql command with the following syntax.
-> psql --host aact-prod.cr4nrslb1lw7.us-east-1.rds.amazonaws.com --port=5432 --username=aact --dbname=aact psql (9.5.3, server 9.5.4) SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off) Type "help" for help. aact=> _
The aact=> prompt indicates that you're in a pSQL console session and can enter SQL queries against the AACT database. A simple example:
aact=> select count(*) from studies; count -------- 259453 (1 row) aact=> _
Important note: To exit pSQL, enter the (not entirely intuitive) command: \q and hit return.
aact=> \q -> _