# Pigsty v0.8.0

> Service Provision

---

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

---

**v0\.8\.0 · 2021-03-28**
- [View release](https://github.com/pgsty/pigsty/releases/tag/v0.8.0)
- [Source · tar\.gz](https://github.com/pgsty/pigsty/archive/refs/tags/v0.8.0.tar.gz)
- [Source · zip](https://github.com/pgsty/pigsty/archive/refs/tags/v0.8.0.zip)
- [pgsty\/pigsty](https://github.com/pgsty/pigsty)

v0.8 finalizes the provisioning API. Services are completely rebuilt: instead of a hard-coded primary/replica pair you can now declare any number of services, plug in HAProxy, swap in an external load balancer, or hand off to a custom VIP controller. Everything else in the supply chain stabilizes on top of this model.

## Service API

The old `vip` and `haproxy` knobs moved under the `service` role. `pg_services` (plus `pg_services_extra`) define each exposed endpoint—name, ports, selectors, health checks, weights, and balancer hints. Selectors are JMESPath filters over cluster members, and optional `selector_backup` pools handle fail-in when replicas are gone. Out of the box we ship `primary`, `replica`, `default`, and `offline` service definitions; swap `dst_port` to point at `postgres`, `pgbouncer`, or any number.

The HAProxy stanza keeps per-service tuning (maxconn, algorithm, timeouts) while VIP config distinguishes L2/L4 implementations so you can drop Pigsty behind an existing load balancer.

## Database Interface Tweaks

Locales can now be split into `lc_collate` and `lc_ctype` so extensions like `pg_trgm` behave with non-`C` collations. The rest of the `pg_databases` schema stays the same—owner/template/encoding/connlimit/revokeconn/pgbouncer/comment—just with better defaults and inline comments.

## Sources

- [GitHub release](https://github.com/pgsty/pigsty/releases/tag/v0.8.0)
- [Pigsty v0.8 release article](https://pigsty.io/blog/pigsty/v0.8/)
- [Historical About / Release Note](https://pigsty.io/docs/about/release/#v080)
- [Source comparison: `v0.7.0...v0.8.0`](https://github.com/pgsty/pigsty/compare/v0.7.0...v0.8.0)