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.
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'
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.
