PostgreSQL is designed to be easily extensible. The extensions loaded into the database can function just like features that are built in. TimescaleDB extends PostgreSQL for time-series data, giving PostgreSQL the high-performance, scalability, and analytical capabilities required by modern data-intensive applications. If you installed TimescaleDB with Homebrew or MacPorts, you can uninstall it without having to uninstall PostgreSQL.
At the
psql
prompt, remove the TimescaleDB extension:DROP EXTENSION timescaledb;At the command prompt, remove
timescaledb
fromshared_preload_libraries
in thepostgresql.conf
configuration file:nano /opt/homebrew/var/postgresql@14/postgresql.confshared_preload_libraries = ''Save the changes to the
postgresql.conf
file.Restart PostgreSQL:
brew services restart postgresqlCheck that the TimescaleDB extension is uninstalled by using the
\dx
command at thepsql
prompt. Output is similar to:tsdb-# \dxList of installed extensionsName | Version | Schema | Description-------------+---------+------------+-------------------------------------------------------------------plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language(1 row)Uninstall TimescaleDB:
brew uninstall timescaledbRemove all the dependencies and related files:
brew remove timescaledb
At the
psql
prompt, remove the TimescaleDB extension:DROP EXTENSION timescaledb;At the command prompt, remove
timescaledb
fromshared_preload_libraries
in thepostgresql.conf
configuration file:nano /opt/homebrew/var/postgresql@14/postgresql.confshared_preload_libraries = ''Save the changes to the
postgresql.conf
file.Restart PostgreSQL:
port reload postgresqlCheck that the TimescaleDB extension is uninstalled by using the
\dx
command at thepsql
prompt. Output is similar to:tsdb-# \dxList of installed extensionsName | Version | Schema | Description-------------+---------+------------+-------------------------------------------------------------------plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language(1 row)Uninstall TimescaleDB and the related dependencies:
port uninstall timescaledb --follow-dependencies
Keywords
Found an issue on this page?Report an issue or Edit this page in GitHub.