v1.1.1 TimescaleDB upgrade and new Patroni Templates

Pigsty v.1.1.1

• Upgrade timescaledb from apache version to timescale version.
• Add a series of new patroni config templates.

The default value for timescaledb.license is apache rather than timescale as the doc describes #3718

Changes

• [ENHANCEMENT] replace timescaledb apache version with timescale version
• [ENHANCEMENT] upgrade prometheus to 2.30
• [ENHANCEMENT] add new patroni config templates
• [BUG FIX] now pg_exporter config dir's owner are {{ pg_dbsu }} instead of prometheus

What's new in patroni config tempaltes?

Now there are a series of pre-defined patroni config templates aims for different machine spec.

Conf Name	CPU	Mem	Disk
tiny	1	1GB	40GB
mini	2	4GB	100GB
small	4	8GB	200GB
medium	8	16GB	500GB
large	16	32GB	1TB
xlarge	32	64GB	2TB
oltp,crit,olap	64	400GB	4TB

How to upgrade from existing setup ?

How to upgrade to v1.1.1 from v1.0.0.
The major change in v1.1.1 is timescaledb. Which replace old apache license version with timescale license version

(reinstall & restart required)

You can failover with patroni, then perform the timescaledb upgrade.

systemctl stop patroni
yum remove -y timescaledb_13

[timescale_timescaledb]
name=timescale_timescaledb
baseurl=https://packagecloud.io/timescale/timescaledb/el/7/$basearch
repo_gpgcheck=0
gpgcheck=0
enabled=1

yum install timescaledb-2-postgresql13