Document installation via MacPorts about docs HOT 17 CLOSED

I haven't updated the Portfile to 2.0.0 yet. Currently port install timescaledb installs 1.7.4.

from docs.

Awesome @blair, that's great to hear! Can I ask a favor? Does macports distribute a binary or source? If binary, can you make sure its built with a flag to cmake like -DPROJECT_INSTALL_METHOD=macports? And for source, add that to the cmake build directive?

This will help us have a better idea of which install methods people are using.

I will check to see what we can do about documentation

from docs.

MacPorts has binary builds. It is built with -DPROJECT_INSTALL_METHOD=macports. You can see the Portfile here:

https://github.com/macports/macports-ports/tree/master/databases/timescaledb

What do you mean, "And for source, add that to the cmake build directive?"? Feel free to suggest any modifications to the Portfile.

from docs.

Awesome, thanks!

What I meant was, if it is a source distribution, just make sure to add the same flag to the cmake directive. But it looks like you already took care of that, so you're all good.

Will keep you posted about documentation, and thanks for doing this!

from docs.

It's not a repackaing of your source package. It's downloading the source archive from github.

from docs.

@blair what are the prerequisites for install? Also, what versions of PostgreSQL and TimescaleDB does this method allow?

from docs.

There's no prerequisites besides installing MacPorts.

Currently MacPorts has TimescaleDB 1.7.4. It only supports installing a single version at the time as specified in https://github.com/macports/macports-ports/blob/master/databases/timescaledb/Portfile . It supports PostgreSQL 9.6.x, 10.x, 11.x and 12.x, but only one version at any one time.

One would install it with port install timescaledb +postgresql96 or port install timescaledb +postgresql10, port install timescaledb +postgresql11 or port install timescaledb +postgresql12 depending upon which version of PostgreSQL to build and install into.

from docs.

Sorry to circle back around to this so late. A question: Does this installation method still only go up to TimescaleDB 1.7.4 or does it cover 2.0.0?

from docs.

QQ are there any requirements post install? Part of our setup usually involves restarting PostgreSQL. Is there any special way required to restart with a MacPorts install?

from docs.

Normally one would ask the user to restart the server themselves. There could be install instructions on the upgrade linking to https://docs.timescale.com/latest/update-timescaledb .

from docs.

@blair does this install require the command /usr/local/bin/timescaledb_move.sh after in the same way that the homebrew install does?

from docs.

I'm not sure that timescaledb_move.sh is needed in MacPorts. The MacPorts installs the files directly into the proper PostgreSQL directory so no moving is needed.

I also updated timescaledb to 2.0.1. I added a timescaledb1 port for 1.7.4.

from docs.

@blair can you please confirm if timescaledb-tune is also installed when timescaledb and postgresql is installed using MacPorts. Because it is installed as a dependency when you install via Homebrew. This is important because to help make configuring TimescaleDB a little easier, we created a tool called timescaledb-tune that handles setting the most common parameters to good values based on your system. It accounts for memory, CPU, and PostgreSQL version.

Here's the output from the macOS that i tried the installation.

rajie@RajakavithasMBP ~ % psql -U postgres -h localhost
psql (14.1)
Type "help" for help.

postgres=# \dx
List of installed extensions
Name | Version | Schema | Description
---------+---------+------------+------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(1 row)

postgres=# exit
rajie@RajakavithasMBP ~ % ports timescaledb contents
zsh: command not found: ports
rajie@RajakavithasMBP ~ % port contents timescaledb
Port timescaledb contains:
/opt/local/lib/postgresql14/timescaledb-2.5.2.so
/opt/local/lib/postgresql14/timescaledb.so
/opt/local/share/postgresql14/extension/timescaledb--1.7.0--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--1.7.1--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--1.7.2--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--1.7.3--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--1.7.4--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--1.7.5--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--2.0.0--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--2.0.0-rc1--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--2.0.0-rc2--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--2.0.0-rc3--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--2.0.0-rc4--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--2.0.1--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--2.0.2--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--2.1.0--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--2.1.1--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--2.2.0--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--2.2.1--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--2.3.0--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--2.3.1--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--2.4.0--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--2.4.1--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--2.4.2--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--2.5.0--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--2.5.1--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb--2.5.2.sql
/opt/local/share/postgresql14/extension/timescaledb.control
rajie@RajakavithasMBP ~ % sudo timescaledb-tune
Password:
sudo: timescaledb-tune: command not found
rajie@RajakavithasMBP ~ %

from docs.

The port doesn't install any of the files in https://github.com/timescale/timescaledb-tune. Probably the best way is to make a new timescaledb-tools port that installs the files.

from docs.

The port doesn't install any of the files in https://github.com/timescale/timescaledb-tune. Probably the best way is to make a new timescaledb-tools port that installs the files.

Thanks @blair that would be awesome. However, I would like to get the thoughts from the rest of the team at timescale. @solugebefola @NunoFilipeSantos @RobAtticus @Loquacity please share your thoughts because we recommend timescaledb-tools .

from docs.

The port doesn't install any of the files in https://github.com/timescale/timescaledb-tune. Probably the best way is to make a new timescaledb-tools port that installs the files.

Thanks @blair that would be awesome. However, I would like to get the thoughts from the rest of the team at timescale. @solugebefola @NunoFilipeSantos @RobAtticus @Loquacity please share your thoughts because we recommend timescaledb-tools .

From a docs perspective, if the procedure changes, we'll update the docs. For now, let's just document what exists.

from docs.

The port doesn't install any of the files in https://github.com/timescale/timescaledb-tune. Probably the best way is to make a new timescaledb-tools port that installs the files.

Hi @blair I just submitted a PR with the instructions to install using MacPorts. Do you have any updates about timescaledb-tools port? that would make it seamless as homebrew installation.

from docs.