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.

Procedure

  1. 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.
  2. 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
  3. Copy the files downloaded Step 3 to the PG_HOME\bin directory.
  4. 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
  5. 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