Uninstalling Stored Procedures on PostgreSQL

If a Team Studio stored procedure installation is incomplete or fails in some way, you can uninstall stored procedures within a PostgreSQL database.

Perform this task in an environment where the PostgreSQL database is installed.

Prerequisites

PostgreSQL must be installed and running.
The PostgreSQL database administrator must own the database_setup directory and all of the content in it.

Extract the installer alpine_miner_installer_postgres.bin.
```
./alpine_miner_installer_postgres.bin --keep --noexec
```
Change to the Postgres folder, where the SQL file alpine_miner_uninstall_functions.sql is located.
```
cd Postgres
```

Run the following code.

psql -d [your database name] -f alpine_miner_uninstall_functions.sql

Remove the alpine_miner.so file from your Postgres binaries folder.
```
rm ${PGHOME}/lib/postgres/alpine_miner.so
```

The stored procedure installation is removed.