Uninstalling TimescaleDB using MacPorts

1. At the psql prompt, remove the TimescaleDB extension:

2. At the command prompt, remove timescaledb from shared_preload_libraries in the postgresql.conf configuration file:

3. Save the changes to the postgresql.conf file.

4. Restart Postgres:

5. Check that the TimescaleDB extension is uninstalled by using the \dx command at the psql prompt. Output is similar to:

6. Uninstall TimescaleDB and the related dependencies:

===== PAGE: https://docs.tigerdata.com/self-hosted/upgrades/about-upgrades/ =====

Examples:

Example 1 (sql):

DROP EXTENSION timescaledb;

Example 2 (bash):

nano /opt/homebrew/var/postgresql@14/postgresql.conf
    shared_preload_libraries = ''

Example 3 (bash):

brew services restart postgresql

Example 4 (sql):

tsdb-# \dx
                                          List of installed extensions
        Name     | Version |   Schema   |                            Description
    -------------+---------+------------+-------------------------------------------------------------------
     plpgsql     | 1.0     | pg_catalog | PL/pgSQL procedural language
    (1 row)