Install self-hosted TimescaleDB on macOS systems
You can host TimescaleDB yourself on your Apple macOS system. These instructions use a Homebrew or MacPorts installer on these versions:
- Apple macOS 10.15 Catalina
- Apple macOS 11 Big Sur
- Apple macOS 12 Monterey
Before you begin installing TimescaleDB, make sure you have installed PostgreSQL version 12 or later.
If you have already installed PostgreSQL using a method other than Homebrew, you could encounter errors following these instructions. It is safest to remove any existing PostgreSQL installations before you begin. If you want to keep your current PostgreSQL installation, do not install TimescaleDB using this method. Install from source instead.
You can use Homebrew to install TimescaleDB on macOS-based systems.
Installing self-hosted TimescaleDB using Homebrew
- Install Homebrew, if you don't already have it:For more information about Homebrew, including installation instructions, see the Homebrew documentation.
/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"
- At the command prompt, add the Timescale Homebrew tap:
brew tap timescale/tap
- Install TimescaleDB:
brew install timescaledb
- Run the
timescaledb-tunescript to configure your database:
timescaledb-tune --quiet --yes
- Change to the directory where the setup script is located. It is typically,
<VERSION>is the version of
timescaledbthat you installed:
- Run the setup script to complete installation.
You can use MacPorts to install TimescaleDB on macOS-based systems.
Installing self-hosted TimescaleDB using MacPorts
- Install MacPorts by downloading and running the package installer. For more information about MacPorts, including installation instructions, see the MacPorts documentation.
- Install TimescaleDB:
sudo port install timescaledb
- OPTIONAL View the files that were installed:
port contents timescaledb
MacPorts does not install the
timescaledb-tools to run the
timescaledb-tune script. For more information about installing and using the tool, see
When you have PostgreSQL and TimescaleDB installed, you can connect to it from
your local system using the
psql command-line utility. This is the same tool
you might have used to connect to PostgreSQL before, but if you haven't
installed it yet, check out our installing psql section.
Setting up the TimescaleDB extension
On your local system, at the command prompt, connect to the PostgreSQL instance as the
psql -U postgres -h localhost
If your connection is successful, you'll see a message like this, followed by the
psql (14.4) Type "help" for help.
psqlprompt, create an empty database named
CREATE database tsdb;
Connect to the
tsdbdatabase that you created:
Add the TimescaleDB extension:
CREATE EXTENSION IF NOT EXISTS timescaledb;
Check that the TimescaleDB extension is installed by using the
\dxcommand at the
psqlprompt. Output is similar to:
```sql tsdb-# \dx List of installed extensions Name | Version | Schema | Description -------------+---------+------------+------------------------------------------------------------------- plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language timescaledb | 2.7.0 | public | Enables scalable inserts and complex queries for time-series data (2 rows) ```
After you have created the extension and the database, you can connect to your database directly using this command:
```bash psql -U postgres -h localhost -d tsdb ```
Now that you have your first TimescaleDB database up and running, you can check out the TimescaleDB section in our documentation, and find out what you can do with it.
If you want to work through some tutorials to help you get up and running with TimescaleDB and time-series data, check out our tutorials section.
You can always contact us if you need help working something out, or if you want to have a chat.
Found an issue on this page?Report an issue!