Add Timescale To PostgreSQL | A Simple Tutorial

This article provides the steps to add Timescale to PostgreSQL. With our 24/7 PostgreSQL Support Services, Bobcares offers solutions to your Postgres issues.

How To Add Timescale To PostgreSQL?

Once we install TimescaleDB and PostgreSQL, we can establish the connection using the

psqlCopy Code

command. The process involves two steps, namely:

1. psqlCopy Code

   Installation
2. TimescaleDB Extension Setup

 

 

Let’s look into the details of each step.

Add Timescale To PostgreSQL –

psqlCopy Code

Installation

1. First, confirm the

aptCopy Code

repository is the latest version.

apt-get updateCopy

2. Then install the package

postgresql-clientCopy Code

.

Add Timescale To PostgreSQL – TimescaleDB Extension Setup

We must stop and start Postgres again and create the TimescaleDB extension. We’ve to run the following steps:

1. Enable the TimescaleDB with

timescaledb-tuneCopy Code

.

2. Restart the service.

systemctl restart postgresql

3. Type the command

psqlCopy Code

in the command prompt as the Postgres superuser in the local machine.

sudo -u postgres psql

4. After a successful connection, we can see the following message.

 

Type “help” for help.

5. In the

psql promptCopy Code

, make the password for the Postgres user.

\password postgres

6. Now exit from PostgreSQL by using the code:

\q

7. In order to connect to PostgreSQL, use the

psqlCopy Code

client.

psql -U postgres -h localhost

8. Make an empty database in the psql prompt. Here, the database is tsdb1:

CREATE database tsdb1;

9. Now establish the connection to the database created:

\c tsdb

10. Finally we can add the TimescaleDB extension using the code:

CREATE EXTENSION IF NOT EXISTS timescaledb;

11. Lastly, make sure the TimescaleDB extension is set up by using the \dx command at the psql prompt.

tsdb-# \dx

12. Following the creation of the extension and database, we can use the following command to establish a direct connection to the database:

psql -U postgres -h localhost -d tsdb

[Looking for a solution to another query? We are just a click away.]

Conclusion

To conclude, we’ve provided the steps from our Support team to add Timescale to PostgreSQL, along with the command to install psql through

aptCopy Code

repository.