Install TimescaleDB on Windows

Install the latest version of PostgreSQL and psql

1. Download PostgreSQL, then run the installer.

   1. In the Select Components dialog, check Command Line Tools, along with any other components you want to install, and click Next.

   2. Complete the installation wizard.

      If you see an error like could not load library "C:/Program Files/PostgreSQL/14/lib/timescaledb-2.16.1.dll": The specified module could not be found., use Dependencies to ensure that your system can find the compatible DLLs for this release of TimescaleDB.

2. Check that you can run pg_config. If you cannot run pg_config from the command line, in the Windows Search tool, enter system environment variables. The path should be C:\Program Files\PostgreSQL\<version>\bin.

Install TimescaleDB

1. Unzip the TimescaleDB installer to <install_dir>.

   Best practice is to use the latest version.

2. In <install_dir>, right-click setup.exe, then choose Run as Administrator.

3. Complete the installation wizard.

Tune your PostgreSQL instance for TimescaleDB

Run the timescaledb-tune script included in the timescaledb-tools package with TimescaleDB. For more information, see configuration.

Login to PostgreSQL as postgres

sudo -u postgres psql

Copy

You are in the psql shell.

Set the password for postgres

\password postgres

Copy

When you have set the password, type \q to exit psql.

Connect to a database on your PostgreSQL instance

In PostgreSQL, the default user and database are both postgres. To use a different database, set <database-name> to the name of that database:

psql -d "postgres://<username>:<password>@<host>:<port>/<database-name>"

Copy

Add TimescaleDB to the database

CREATE EXTENSION IF NOT EXISTS timescaledb;

Copy

Check that TimescaleDB is installed

\dx

Copy

You see the list of installed extensions:

List of installed extensions
Name     | Version |   Schema   |                                      Description                                      
-------------+---------+------------+---------------------------------------------------------------------------------------
plpgsql     | 1.0     | pg_catalog | PL/pgSQL procedural language
timescaledb | 2.15.1  | public     | Enables scalable inserts and complex queries for time-series data (Community Edition)

Copy

Press q to exit the list of extensions.