# Installing Timescaledb on Postgres App(macOS)

Recently, while working on one of the projects. I came across the requirement to use Timescaledb. I use [postgress.app](https://postgresapp.com/) for managing different versions of PostgreSQL for different projects. This was my first encounter with `timescaledb`, I had never used it before. So, I started to look at the official [documentation](https://docs.timescale.com/install/latest/self-hosted/installation-macos/#install-self-hosted-timescaledb-using-homebrew) and follow the steps mentioned in the macOS (section). One thing, I was sure of after reading the documentation is that these steps will not be going to work in my case(with postgress.app). My suspicion was right and I struggled in configuring it. This mini blog is about the insight steps that I learned from different sources on the internet while installing timescaledb.

### Steps
- The most obvious requirement for installing `timescaledb` is to have Postgress.app installed.
- After installing Postgres.app we will install the timescaledb. For this, we will follow below steps from the official [documentation](
https://docs.timescale.com/install/latest/self-hosted/installation-macos/#install-self-hosted-timescaledb-using-homebrew).
- Open your terminal and run 
   - `brew tap timescale/tap`
   - `brew install timescaledb`
- Next, we have to run `timescaledb-tune` which requires passing the `Postgres` path with the version number of Postgres.(**NOTE:** Suppose, you have multiple version of Postgres say 13 and 14 and we want to install  timescaledb on version 14 so we will use `var-14` in the `conf-path`).
- Run following script
```
timescaledb-tune --yes --conf-path=/Users/<user_name>/Library/Application\ Support/Postgres/var-14/postgresql.conf
```
- Navigate to `/opt/homebrew/Cellar/timescaledb/` and you will see folder with some number, it is nothing but timescaledb version. In my case, it is `2.8.1` so we will be using it in the below script. So, run the below script with your timescaledb number.

```
/usr/bin/install -c -m 755 $(find /opt/homebrew/Cellar/timescaledb/2.8.1/lib/timescaledb/postgresql@14/ -name "timescaledb*.so")  /Applications/Postgres.app/Contents/Versions/14/lib/postgresql

/usr/bin/install -c -m 644 /opt/homebrew/Cellar/timescaledb/2.8.1/share/timescaledb/* /Applications/Postgres.app/Contents/Versions/14/share/postgresql/extension/
```

- After this open the Postgress app and click the `Server Settings` button
![Screenshot 2022-10-06 at 6.04.00 PM.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1665059645555/EimdSMME-.png align="left")
- It will open a popup on which will click on the `show` button of `config` i.e second option.
![Screenshot 2022-10-06 at 6.05.15 PM.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1665059721354/iprRfcDiR.png align="left")
- This will open a folder with `postgresql.conf` file selected. Now, open this file and add the following lines at the end of the file.
```
shared_preload_libraries = 'timescaledb'
```
- Now, restart the Postgres app. Double click on your database from the list of the database in the app. It will open the command prompt of the selected database. After that run the following command
```
CREATE EXTENSION IF NOT EXISTS timescaledb;
```
- This will add timescaledb for your particular database.

I hope you like this blog. If you have any questions then please comment below. Thanks for reading 😊.

### References
- [Postgress.app](https://postgresapp.com/)
- [TimescaleDB](https://www.timescale.com/)
- [Timescale Installation](https://docs.timescale.com/install/latest/self-hosted/installation-macos/#install-self-hosted-timescaledb-using-homebrew)
- [Stackoverflow (Thank you Dr. Manhattan)](https://stackoverflow.com/a/73248120/8456101)