# Pigsty v2.3.0

> Node VIP, FerretDB, NocoDB, MySQL stub, CVE fixes

---

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

---

**v2\.3\.0 · 2023-08-20**
- [View release](https://github.com/pgsty/pigsty/releases/tag/v2.3.0)
- [Source · tar\.gz](https://github.com/pgsty/pigsty/archive/refs/tags/v2.3.0.tar.gz)
- [Source · zip](https://github.com/pgsty/pigsty/archive/refs/tags/v2.3.0.zip)
- [pgsty\/pigsty](https://github.com/pgsty/pigsty)

## Highlights

* INFRA: Added NODE/PGSQL VIP monitoring support
* PGSQL: Fixed PostgreSQL [CVE-2023-39417](https://www.postgresql.org/about/news/postgresql-154-149-1312-1216-1121-and-postgresql-16-beta-3-released-2689/) via minor upgrades: 15.4, 14.9, 13.12, 12.16, and Patroni v3.1.0
* NODE: Allow users to bind L2 VIP to node clusters using `keepalived`
* REPO: Pigsty Yum repo optimized, site-wide HTTPS by default: [`get.pigsty.cc`](https://get.pigsty.cc) and [`demo.pigsty.cc`](https://demo.pigsty.cc)
* APP: Upgraded `app/bytebase` to v2.6.0, `app/ferretdb` to v1.8; added new app template: [NocoDB](https://nocodb.com/), open-source Airtable
* REDIS: Upgraded to v7.2, redesigned Redis dashboards
* MONGO: Added basic support via [FerretDB](https://www.ferretdb.io/) 1.8
* MYSQL: Added Prometheus/Grafana/CA stubs for future integration

## API Changes

Added new parameter group `NODE`.`NODE_VIP` with 8 new parameters:

- `NODE`.`VIP`.`vip_enabled`: Enable VIP on this node cluster?
- `NODE`.`VIP`.`vip_address`: Node VIP address in IPv4 format, required if VIP enabled
- `NODE`.`VIP`.`vip_vrid`: Required, integer 1-255, must be unique within same VLAN
- `NODE`.`VIP`.`vip_role`: master/backup, defaults to backup, used as initial role
- `NODE`.`VIP`.`vip_preempt`: Optional, true/false, defaults to false, enable VIP preemption
- `NODE`.`VIP`.`vip_interface`: Node VIP network interface to listen on, eth0 by default
- `NODE`.`VIP`.`vip_dns_suffix`: Node VIP DNS name suffix, defaults to .vip
- `NODE`.`VIP`.`vip_exporter_port`: Keepalived exporter listen port, defaults to 9650

```bash
MD5 (pigsty-pkg-v2.3.0.el7.x86_64.tgz) = 81db95f1c591008725175d280ad23615
MD5 (pigsty-pkg-v2.3.0.el8.x86_64.tgz) = 6f4d169b36f6ec4aa33bfd5901c9abbe
MD5 (pigsty-pkg-v2.3.0.el9.x86_64.tgz) = 4bc9ae920e7de6dd8988ca7ee681459d
```

## Sources

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