Installing Team Studio DLLs in a PostgreSQL database on Windows

Follow these steps to install Team Studio stored procedures within a PostgreSQL database on Windows.

Perform this task on the server side for the PostgreSQL data base on a Windows computer.

Prerequisites

PostgreSQL must be installed and running.
The PostgreSQL database administrator must own the database_setup directory and all the content in it.
Determine whether you need to the 64-bit or the 32-bit DLL file.

From your Team Studio installation, install the appropriate DLL file.
- Download alpine_miner.64bit.dll for 64-bit.
- Download alpine_miner.dll for 32-bit.
From the Team Studio database setup, set up the file Postgres.zip.
This file contains two SQL files.
- create_demo_db.sql
- alpine_miner_setup.sql
Copy the files downloaded Step 3 to the PG_HOME\bin directory.
Verify the installation is correct by installing the miner_demo database.
From the command prompt, use the following command. (In this example, we use the template1 database and the postgres user.)
```
PG_HOME\bin\psql.exe -f create_demo_db.sql -d template1 -U postgres
```
Install the functions to the database that Team Studio workflow operators work with).
In this example, we use the miner_demo database, and the postgres user.
```
PG_HOME\bin\psql.exe  -f alpine_miner_setup.sql -d miner_demo -U postgres
```