# PgStack

> PgStack is a self-hosted, open-source tool that creates search and audit read replicas of your Postgres database via logical replication.

- **Category:** Search Engines
- **Licence:** AGPL-3.0
- **Latest version:** v2.2.0
- **Open source:** oss
- **Languages:** Go
- **Platforms:** Docker
- **Tags:** PostgreSQL, Search, Semantic Search, Vector Search, Audit, Hybrid Search, Docker, Cdc, Bm25, Postgres, Change Data Capture, Logical Replication, Read Replica

## Description

PgStack links to a Postgres database through logical replication and builds two read-only replicas. One replica focuses on search, offering keyword, semantic, and combined ranking with optional OpenAI embeddings. The other replica records every row change with before and after snapshots for auditing. The software runs in one Docker container and serves a Postgres-compatible SQL interface on port 54321. A YAML file controls which tables and columns are indexed. The core is AGPL-3.0 licensed, while a paid cloud edition provides a web dashboard, team features, managed embeddings, autoscaling, and hardened security.

## Links

- [Homepage](https://github.com/pgstack-io/bemidb)
- [Website](pgstack.io)
- [Docker](ghcr.io/pgstack-io/pgstack)
- [Documentation](https://github.com/pgstack-io/pgstack)
- [Releases](https://github.com/pgstack-io/pgstack/releases)
- [Pricing](https://pgstack.io/pricing/search)

---
Source: https://selfhost.directory/project/bemidb