Feng Ruohang

### What happened? My workflow involves the use of Python scripts to load Grafana dashboards via the HTTP API. This process has been reliable and efficient until the recent upgrade...

Pigsty v2.8 feature planning

1

- [ ] Grafana 11 migration - [ ] PG Exporter 0.7 for PG 17 - [ ] PG 17 beta template - [ ] Observability enhancement - [ ]...

write `proxy_env` to docker daemon.json if applicable

1

Since docker hub is banned in China... We'll have proxy env for docker daemon.

Zabbix 7.0 is using PostgreSQL as underlying storage. We can have a docker compose template for that.

Dify is using PostgreSQL & pgvector as underlying storage. We can have a docker compose template for that

New `jackc/pgx` driver does not work well with pgbouncer metrics

6

Two problems with the new `jackc/pgx` drvier when working with pgBouncer: Pgbouncer works with `SimpleQueryProtocol`, which can be solved by: ```go config, err := pgx.ParseConfig(s.dsn) config.DefaultQueryExecMode = pgx.QueryExecModeSimpleProtocol ``` The...

Runtime crash with libduckdb 1.0.0

1

```bash postgres=# create extension duckdb_fdw; CREATE EXTENSION postgres=# CREATE SERVER duckdb_server postgres-# FOREIGN DATA WRAPPER duckdb_fdw postgres-# OPTIONS ( postgres(# database '/tmp/duck.db' postgres(# ); CREATE SERVER postgres=# CREATE FOREIGN TABLE...

Use separated libduckdb.so rpm / deb

3

How about using a separate libduckdb.so in /usr/lib64/ instead of an embedded one? `libduckdb.so` is independent of the PostgreSQL major version. If you plan to install `pg_duckdb_16` and `pg_duckdb_17` (in...

- [x] Grafana Dashboard Titles - [ ] Grafana Dashboard Panels - [x] Prometheus Alerting Rules

For example, if you configure some parameter that requires a server restart. Such as the `pg_cron` param `cron.database_name`, you'll have to restart after the provision takes effect. However, we can...