Uninstalling Stored Procedures on Greenplum

In the case where a Team Studio stored procedure installation is incomplete or fails in some way, you can uninstall stored procedures within a Greenplum database (GPDB).

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

Prerequisites

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

Procedure

  1. Extract the installer alpine_miner_installer_Greenplum.bin. 
    ./alpine_miner_installer_Greenplum.bin --keep --noexec
  2. Change to the Greenplum folder, where the SQL file alpine_miner_uninstall_functions.sql is located. 
    cd Greenplum
  3. Run the following code. 
    psql -d [your database name] -f alpine_miner_uninstall_functions.sql
  4. Remove the alpine_miner.so file from your Greenplum binaries folder. 
    rm ${GPHOME}/lib/postgresql/alpine_miner.so

Result

The stored procedure installation is removed.
Related tasks