# Pigsty v2.3.1

> PGVector with HNSW, PG16 RC1, doc refresh, Chinese docs, bug fixes

---

LLMS index: [llms.txt](/llms.txt)

---

**v2\.3\.1 · 2023-09-01**
- [View release](https://github.com/pgsty/pigsty/releases/tag/v2.3.1)
- [Source · tar\.gz](https://github.com/pgsty/pigsty/archive/refs/tags/v2.3.1.tar.gz)
- [Source · zip](https://github.com/pgsty/pigsty/archive/refs/tags/v2.3.1.zip)
- [pgsty\/pigsty](https://github.com/pgsty/pigsty)

## Highlights

- `pgvector` updated to 0.5 with HNSW algorithm support
- PostgreSQL 16 RC1 support (el8/el9)
- Added SealOS to default packages for quick Kubernetes cluster deployment

## Bug Fixes

- Fixed `infra`.`repo`.`repo_pkg` task: downloads could be affected by existing `/www/pigsty` content when `repo_packages` contains `*` wildcards
- Changed `vip_dns_suffix` default from `.vip` to empty string, so cluster name itself becomes the default Node cluster L2 VIP
- `modprobe watchdog` and `chown watchdog` if `patroni_watchdog_mode` is `required`
- When `pg_dbsu_sudo` = `limit` and `patroni_watchdog_mode` = `required`, grant database dbsu sudo for:
  - `/usr/bin/sudo /sbin/modprobe softdog`: Ensure softdog kernel module enabled when starting Patroni service
  - `/usr/bin/sudo /bin/chown {{ pg_dbsu }} /dev/watchdog`: Ensure watchdog ownership correct when starting Patroni service

## Documentation Updates

- Added updated content to English documentation
- Added simplified Chinese built-in docs, fixed Chinese docs on pigsty.cc

## Software Updates

- PostgreSQL 16 RC1 for EL8/EL9
- PGVector 0.5.0 with HNSW index support
- TimescaleDB 2.11.2
- Grafana 10.1.0
- Loki & Promtail 2.8.4
- Redis Stack 7.2 on el7/8
- mcli-20230829225506 / minio-20230829230735
- FerretDB 1.9
- SealOS 4.3.3
- pgBadger 1.12.2

```bash
MD5 (pigsty-pkg-v2.3.1.el7.x86_64.tgz) = ce69791eb622fa87c543096cdf11f970
MD5 (pigsty-pkg-v2.3.1.el8.x86_64.tgz) = 495aba9d6d18ce1ebed6271e6c96b63a
MD5 (pigsty-pkg-v2.3.1.el9.x86_64.tgz) = 38b45582cbc337ff363144980d0d7b64
```

## Sources

- [GitHub release](https://github.com/pgsty/pigsty/releases/tag/v2.3.1)
- [Pigsty v2.3 release article](https://pigsty.io/blog/pigsty/v2.3/)
- [Historical About / Release Note](https://pigsty.io/docs/about/release/#v231)
- [Source comparison: `v2.3.0...v2.3.1`](https://github.com/pgsty/pigsty/compare/v2.3.0...v2.3.1)