install

Additional install commands

macOS

Homebrewverified · 100%

brew install pgroonga

local Homebrew formula metadata

overview

Package summary

PostgreSQL plugin to use Groonga as index

Project links

Commands and aliases

pgroonga-generate-primary-maintainer-service.sh
pgroonga-generate-primary-maintainer-timer.sh
pgroonga-primary-maintainer.sh

history

Project history and usage

PGroonga is a PostgreSQL extension that uses Groonga as an index, adding fast multilingual full-text search along with regular-expression, similarity, array, JSON, equality, and range-search capabilities.

Project history

PGroonga's first release was published on January 29, 2015, followed by version 1.0.0 on October 29, 2015. Early releases rapidly added data-type support, customizable tokenizers and normalizers, Windows packages, highlighting, snippets, and JSONB indexing.

Version 2.0.0 arrived on August 17, 2017. It introduced PostgreSQL logical-replication support and moved functions, operators, and operator classes toward `pgroonga_`-prefixed names in the current schema while retaining backward compatibility with the original API.

Adoption history

PGroonga was packaged across Linux distributions and Windows as its supported PostgreSQL and Groonga matrix grew. Its news archive records continuing platform additions, PostgreSQL-major support, replication work, and production-oriented maintenance.

The extension's principal adoption niche is fast multilingual full-text search inside PostgreSQL, especially where built-in indexing and tokenization are insufficient for Japanese and other language-independent search requirements.

How it is used

After installing the extension files, a database administrator runs `CREATE EXTENSION pgroonga` and creates indexes with `CREATE INDEX ... USING pgroonga`. Applications then query through PGroonga operators and functions while remaining inside PostgreSQL SQL.

PGroonga uses PostgreSQL extension settings and SQL objects rather than a standalone user configuration or credentials file. Optional behavior is controlled through PostgreSQL parameters, index options, and SQL.

Why package nerds care

PGroonga is an unusual cross-ecosystem package: a PostgreSQL extension that embeds the Groonga search engine as an index access method. It gives SQL users Groonga's multilingual search without operating a separate search service.

It is also valuable to extension packagers because compatibility spans PostgreSQL, Groonga, operating-system packages, replication behavior, and extension upgrade SQL—not merely one executable.

Timeline

2015: The first PGroonga release was published on January 29.
2015: PGroonga 1.0.0 was released on October 29.
2017: PGroonga 2.0.0 added logical-replication support and introduced the current prefixed API.
2025: PGroonga 4.0.0 removed the long-deprecated version 1 API.

Related projects

Groonga supplies the underlying full-text search engine and indexing capabilities.
PostgreSQL supplies the extension system, SQL interface, and index-access framework through which PGroonga operates.

Sources

security posture

Risk level: blue

broad file, network, media, or database tool signal.

Risk classifier

blue risk · medium confidence · tool

Why

broad file, network, media, or database tool signal

Signals

text:sql

Install behavior

No Homebrew post-install hook is recorded in formula metadata.
Homebrew bottle metadata is available for 5 platform targets.
Installs with 3 runtime dependencies.
Build metadata lists 5 build dependencies.

Recommended review

Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.

executables

Installed executables

Command	Kind	Exposure
`pgroonga-generate-primary-maintainer-service.sh`	cli	global executable
`pgroonga-generate-primary-maintainer-timer.sh`	cli	global executable
`pgroonga-primary-maintainer.sh`	cli	global executable

freshness

Version and freshness

These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.

page generated2026-11-04

manager version4.1.0

manager updated2026-10-09

local dataok

upstreamnot checked

latest detectednot detected

https://pgroonga.github.io/

infoRelease/tag comparison is only available for GitHub repositories.https://pgroonga.github.io/none confidence

install metadata

Package metadata

Package key	brew:pgroonga
Version	4.1.0
Package manager	Homebrew
Package manager page	https://formulae.brew.sh/formula/pgroonga
Homepage	https://pgroonga.github.io/
Upstream docs	https://pgroonga.github.io/
License	PostgreSQL
Source archive	https://packages.groonga.org/source/pgroonga/pgroonga-4.1.0.tar.gz
Last updated	2026-10-09T06:21:25Z
Pulse	updated
Dependencies	groonga, msgpack, xxhash
Build dependencies	meson, ninja, pkgconf, postgresql@17, postgresql@18
Bottle	available (on arm64_golden_gate, arm64_linux, arm64_sequoia, arm64_tahoe, x86_64_linux)
Homebrew post-install	not defined
Service	none declared

registry facts

Source database details

Source Database	Homebrew formula API
Tap	homebrew/core
Full Name	pgroonga
Version Scheme	0
Revision	0
Bottle Stable Root URL	https://ghcr.io/v2/homebrew/core
Deprecated	no
Disabled	no
Keg Only	no
URL Keys	stable

package graph

Links come from deterministic package relationships, av.db category and tag curation, ecosystem matches, and package hub membership.

source trail

Generated from repository data

This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.

Combined YAML source

View the package source record on GitHub.

combined/pgroonga.yml

Used sources

Geiger risk classifier
cross-ecosystem install command graph
curated package history
package relationship graph
package version freshness
package-page enrichment
pkg.so package database
pkgdb category and tag curation

Install pgroonga with Homebrew