Uninstalling Stored Procedures on HAWQ

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

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

Prerequisites

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

Procedure

  1. Extract the installer alpine_miner_installer_hawq.bin. 
    ./alpine_miner_installer_hawq.bin --keep --noexec
  2. Change to the HAWQ folder, where the SQL file alpine_miner_uninstall_functions.sql is located. 
    cd HAWQ
  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 HAWQ binaries folder. 
    rm ${GPHOME}/lib/hawq/alpine_miner.so

Result

The stored procedure installation is removed.
Related tasks