v1.1 HomePage & Client Utils

Demo

Check http://home.pigsty.cc for the brand new user interface! (home page) 🎉

Enhancements

• [ENHANCEMENT] home page overhaul
• [ENHANCEMENT] add jupyter lab integration
• [ENHANCEMENT] add pgweb console integration
• [ENHANCEMENT] add pgbadger support
• [ENHANCEMENT] add pev2 support, explain visualizer
• [ENHANCEMENT] add pglog utils
• [ENHANCEMENT] update default pkg.tgz software version:
• [ENHANCEMENT] add pg_dummy_filesize to create fs space placeholder
• [ENHANCEMENT] now haproxy admin proxy are served under default server (h.pigsty is no longer needed)
• [ENHANCEMENT] add a new example app: applog which could visualize Apple iOS15 privacy log with grafana dashboards.
• [ENHANCEMENT] add promscale to default pkg.tgz (replace prometheus tsdb with timescaledb)

Software Upgrades

• upgrade postgres to v13.4 (with official pg14 support)
• upgrade pgbouncer to v1.16 (metrics definition updates)
• upgrade grafana to v8.1.4
• upgrade prometheus to v2.2.29
• upgrade node_exporter to v1.2.2
• upgrade haproxy to v2.1.1
• upgrade consul to v1.10.2
• upgrade vip-manager to v1.0.1

Bug Fixes

• pgbouncer 1.16 SHOW POOLS, SHOW DATABASES returns an extra column
• ignore errors when provisioning database in existing clusters (skip instead of halt)

API Changes

• nginx_upstream now holds different structures. (incompatible)
• new config entries: app_list, render into home page's nav entries
• new config entries: docs_enabled, setup local docs on default server.
• new config entries: pev2_enabled, setup local pev2 utils.
• new config entries: pgbadger_enabled, create log summary/report dir
• new config entries: jupyter_enabled, enable jupyter lab server on meta node
• new config entries: jupyter_username, specify which user to run jupyter lab
• new config entries: jupyter_password, specify jupyter lab default password
• new config entries: pgweb_enabled, enable pgweb server on meta node
• new config entries: pgweb_username, specify which user to run pgweb
• rename internal flag repo_exist into repo_exists (internal)
• now default value for repo_address is pigsty instead of yum.pigsty
• now haproxy access point is http://pigsty instead of http://h.pigsty