An Industrial IOT Platform

TimescaleDB Setup for Windows 10

Work in progress
Downloads are currently not available
Contact us for demo

Getting Started

TimescaleDB is a superfast SQL Timeseries Database built upon PostgreSQL. PostgreSQL is a free and open source database.
Note: TimescaleDB is no longer supported by Open-Plant. We decided to use InfluxDB instead. Please see why we decided to use InfluxDB instead of TimescaleDB

1) Download PostgreSQL

First and foremost, Install Postgre SQL 11 from the following link. As of 2020, even though PostgreSQL is already version 12, Timescale runs on version 11.
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
The PostgreSQL installer is about 190MB in size

2) Install PostgreSQL

Once downloaded run the installation wizard. For the installation directory, we recommend to leave it as it is. This will make things easy for future users to troubleshoot PostgreSQL related issues as the installations are standardized.

Put a decent password as this may be a legal IoT requirement in some countries.


Default Port if 5432

Postgre uses Port 5432 as default. It is recommended to leave this as it is to minimize confusion for future users.

Installation complete

Postgre uses Port 5432 as default. It is recommended to leave this as it is to minimize confusion for future users.


3) Open Stack Builder and select npgsql

Npgsql provides PostgreSQL connectivity for C# .NET which is the engine used in Open-Plant Analytic Scripts

Install Npgsql for Microsoft .Net 4.5

This step will install the NpgSql after it has been downloaded

PostgreSQL should be running as a Windows Service

If everything went successful, PostgreSQL should appear in Windows Services with status' Running'

PostgreSQL can be managed using pgAdmin

pgAdmin can be accessed from the start menu

4) Download TimescaleDB

Download TimescaleDB from the following link:
https://docs.timescale.com/latest/getting-started/installation/windows/installation-windows
Make sure all the prerequisites are installed

5) Stop PostgreSQL Service

Open Windows services and stop the PostgreSQL service.

6) Run TimescaleDB Setup as Administrator

Extract the downloaded zip file and run setup.exe as Administrator. To run as administrator rightclick and select 'run as Administrator'.
Click on Environment Variables in the Advanced System Settings
To fix this open Advanced System Setting under:
Under Environment Variables click on Path Edit
Find the bin folder location of PostgreSQL which is usually at:
C:Program FilesPostgreSQL11bin
Copy this location
Back at the environment variables 'path edit', click 'new; and add the copied location.

Click on OK > OK > OK, until all is applied

7) Run TimescaleDB setup as Administrator again

Extract the downloaded zip file and run setup.exe as Administrator. To run as administrator rightclick and select 'run as Administrator'.

8) Run timescaledb-tune

The setup will ask to run Timescaledbtune. Select Yes(Y).

This is important to ensure timescaledb works at optimum performance.

The setup will ask for the 'postgresql.conf' file. This is the PostgreSQL config file. Usually the conf file is located at the following: 
C:Program FilesPostgreSQL11data
Click Yes(Y) on all additional prompts.

TimescaleDB setup should be successful
Open-Plant is a revolutionary Industrial IOT Platform software, used to create and deploy Industrial IT apps/solutions. It is an all-encompassing solution offering both back-end and front-end components i.e. the full stack. From our user's experience, creating and deploying Industrial IT apps became 10x faster and 10x less cost. We serve the mining, energy, oil & gas, construction and manufacturing industry. 

OPEN-PLANT PTY LTD

Perth, Australia

EMAIL

info@open-plant.com
homedownloadexclamation-triangleenvelope