Install a Copy of AACT on Windows 10

The following information is based on our experience downloading PostgreSQL 9.6.9 from the Enterprise DB website and installing it on a Windows 10 machine. This was done in early July, 2018.

1

Download PostgreSQL

The URL is: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

Download postgres

The site starts by asking which version of PostgreSQL you want and the operating system of the machine you're downloading to. AACT is currently running on PostgreSQL version 9.6.6, so versions subsequent to that should work. For this demo, we chose version 6.9.6. If you're downloading to Windows or Linux, you need to specify whether you're on a 32 or 64 bit machine.

We googled to find these instructions about determining if your machine is 32 or 64 bit:

Pg windows system type2

When we did this, we determined our machine to be 64 bit (see the value for 'System type:' in the screenshot below). Therefore we selected Windows x86-64 from the dropdown.

Pg windows system type

With these two values specified, we pressed the [Download Now] button.

Windows system type select

2

Install PostgreSQL

The website will ask what you want to do once the file finishes downloading. Select [Run] so that it automatically launches the process that installs the software.

Run executable

Choose [Yes] when it asks if you allow the app to make changes to your device.

Allow changes

This will fire off the setup wizard. Click [ Next > ] buttons (accepting all defaults) until it prompts you for the superuser password. Enter a password you will remember! You'll need it later to access PostgreSql & create the AACT database.

Launch setup wizard

You should see a progress bar showing that it is installing PostgreSQL

Installing progress bar

Unless you intend to develop an application or additional functionality that uses PostgreSQL databases, you will not need to install additional PostgreSQL features/utilitites, so exit when it completes the main installation.

3

Create the AACT database

You can use pgAdmin to create and populate local database instances. Left click the Windows icon in the lower left and scroll down the list of icons until you see to PostgreSQL icon. Click on it to expand the list of PostgreSQL tools and click on pgAdmin 4.

Pg admin 4 icon

When you click pgAdmin 4, it will launch the tool that allows you to create a local version of the AACT database and populate it from a static copy that's available from the AACT website. (pgAdmin is also a great tool for querying the database once it's populated.) The window it presents should look something like this:

Launch pg admin

In the left pane, double-click on Servers and navigate down to Databases. Once there, click on [Objects] from the menu across the top of the page, and select Create and then Database....

Objects create database

This should present an input dialog box that allows you to define a new database. Enter the database name: 'AACT' in the first input box, and before you press [Save], click the Security tab.

Create database aact

Click the little plus icon to the right of 'Privileges' and then under 'Grantee' select PUBLIC from the drop down and assign it All Privileges by clicking in the 'Privileges' cell next to PUBLIC and checking the box next to 'All'.

Grant public rights to db

Grant db access to public

Now you can press [Save].

4

Create database role: ctti

You need to create a specific database user/role to import data from AACT. This is because all database objects in the AACT dump file (the file which will be used to populate your local instance of AACT) are owned by a user named ctti. If the role doesn't exist, you will get error messages that look something like:

Missing ctti role error message

(We intend to modify the database dump process to avoid the need for you to create a database user/role named ctti, but for now, it's necessary.)

In the left pane, select PostgreSQL 9.6 and then select Object - Create - Login/Group Role.

Create role

In the 'Create - Login/Group Role' dialog that pops up, enter ctti in the Name input field.

Create ctti role

Then select the 'Privileges' tab at the top of the dialog and set 'Can Login?' to 'Yes'.

Create role ctti privs

Then press [Save]

5

Populate the AACT database

Download a static copy of the AACT database from the AACT Download Page, and unzip the resulting zip file. It will unpack a set of files that include documentation and a dump file of the AACT database. The file you need for populating your local database copy is postgres_data.dmp.

Download directory

Aact zipfile contents

You can populate the database using the following command:

    

> C:\Program Files\PostgreSQL\9.6.9\bin\pg_restore.exe --host "127.0.0.1" --port "5432" --username "postgres" --no-password --role "ctti" --dbname "aact" --verbose "C:\\<directory containing downloaded file>\\postgres_data.dmp"

Alternatively, you can take the following steps to populate the database using the pgAdmin tool.

You can import the content of postgres_data.dmp file into your new database by selecting the AACT database in the left pane and then clicking [Tools] in the top menu bar of pgAdmin and then click Restore... in the dropdown menu.

Restore aact db

You'll need to click the elipses to the right of the Filename input box. This will present a 'Select file' dialog box.

Select restore file

Navigate to the directory where the postgres_data.dmp file has been downloaded to your machine. Before you can do this though, you must select 'All Files' in the dropdown that appears in the lower right corner. The postgres_data.dmp file will not display unless 'All files' is selected.

Select restore file dropdown

Double click on postgres_data.dmp. You'll return to the 'Restore (Database: AACT)' dialog box where you can press [Restore] to initiate the process that will import the contents of the dump file into the new AACT database.

Restore from static copy

The process will take several minutes. While it's loading, the following message will display:

Restoring db message