I have apache, how to convert it to community

TimescaleDB and PostgreSQL
1

I have apache, how to convert it to community. I am using postgres12 and timescale 2.10.

I checked this but i didnt understand properly.

Also could you please show me the place where i can download the packages for community edition?

2

Hi @animesh, you can find all details of packaging on the .github/workflows which contains all scripts and configurations to distribute the packages. Examples from apt packages.

You can also find the versions on the releases of the official repository.

3

Hi @jonatasdp ,can you please provide me the link, to download the packages? Also are there any steps to follow to convert apache to community?

4

Hi @animesh , I put links in my previous message to packages and examples for all necessary steps for building it. Have you checked them?

5

Hi,

The above did not help me unfortunately.
I also installed timescaledb from the postgres repo(Apache license) and want to replace this with the community edition.

My setup is Postgres15 on RHEL8.

I did the following:
based on: Timescale docs
Added repo: baseurl=https://packagecloud.io/timescale/timescaledb/el/$(rpm -E %{rhel})/$basearch
yum install timescaledb-2-postgresql-15
yum list installed timescaledb*
Installed Packages
timescaledb-2-loader-postgresql-15.x86_64 2.16.1-0.el8 timescale_timescaledb_el8_x86_64
timescaledb-2-postgresql-15.x86_64 2.16.1-0.el8 timescale_timescaledb_el8_x86_64
timescaledb-tools.x86_64 0.15.0-0.el8 timescale_timescaledb_el8_x86_64
timescaledb_15.x86_64 2.15.3-1PGDG.rhel8 postgresql15_el8_x86_64

systemctl restart postgres
psql -X alter extension timescaledb update;
\dx timescaledb
List of installed extensions
Name | Version | Schema | Description
------------±------------±-------±-------------------------------------------------------
timescaledb | 2.16.1 | public | Enables scalable inserts and complex queries for time-series data
(1 row)

Judging by the version, the community edition is now being used.
But if I uninstall timescaledb_15.x86_64 and then restart postgres, it will not start because Postgres cannot find the library.

My questions are:

  • How can I request the edition in the database?
  • And how do I make sure that the timescaledb_15.x86_64 (apache license) is no longer needed?
  • Is this the correct procedure?
  • If this is not the correct procedure, where can I find the correct instructions?

Hope you can help me!

Greetings,
Steven

6

Solved the problem.

If you remove the package timescaledb_15(apache licence) it removes a bit to much(don’t know which component).

Would be nice if this could be fixed.

A workaround is to remove the packages:
timescaledb-2-loader-postgresql-15.x86_64 2.16.1-0.el8 timescale_timescaledb_el8_x86_64
timescaledb-2-postgresql-15.x86_64 2.16.1-0.el8 timescale_timescaledb_el8_x86_64

And install them again.

The dependent component is then reinstalled which was removed by timescaledb_15.x86_64 2.15.3-1PGDG.rhel8 postgresql15_el8_x86_64

1 Like