PGroonga on Ubuntu 24.04 LTS

This is a repackaged open source product with additional charges for cloudimg support services.

PGroonga by cloudimg

A PostgreSQL database with fast, accurate, multilingual full-text search built in. This image delivers PostgreSQL 16.14 with the PGroonga extension at the pinned upstream release 4.0.8, already installed and ready, with a worked full-text search demonstration in English and Japanese the moment the machine boots.

What It Does

PGroonga adds full-text search to PostgreSQL, backed by the Groonga search engine. You build an index on a text column with USING pgroonga, then query it with the full-text match operator. Because the search runs inside the database on an inverted index, it stays fast as the table grows, and it works across natural languages from one index.

Where it stands out:

• Fast search at scale. Full-text queries use the PGroonga index instead of a sequential scan, so they stay quick on large tables.
• Multilingual out of the box. The same index searches English and CJK text (Japanese, Chinese, Korean) with no extra configuration. This is where PGroonga is much stronger than the built-in tokenizers, which struggle with languages that do not separate words with spaces.
• Relevance ranking. A scoring function returns a relevance score for each match, so you can order the best hits first behind a search box.

What Is Included

• PostgreSQL 16.14 from the official PostgreSQL PGDG repository, running under systemd
• PGroonga 4.0.8 from the Groonga project's own package repository, upstream's supported channel, with the signing key pinned by fingerprint before installation
• The extension created in a demonstration database with a mixed English and Japanese document corpus and two PGroonga indexes already built
• A least-privilege application role for your app to run full-text queries, separate from the administrator
• Fully patched base with unattended security upgrades enabled
• 24/7 cloudimg engineers handling upgrades, tuning and configuration

Secure By Default

Every role in the shipped image has no password at all, and TLS is disabled, so the database cannot be reached from the network in the image itself. On first boot each machine mints unique passwords for the administrative and application roles plus a unique TLS certificate, into a file only root can read. Two machines never share a secret, and this is proven by launching two and comparing. Remote clients are accepted only over TLS, and no trust rule exists anywhere in the access configuration.

A credential guard runs on every boot. It proves the recorded credential genuinely authenticates, then attempts authentication with published and example values, including those used in the documentation. If any succeeds it stops the database rather than serve a known credential. It authenticates rather than inspects, because the database stores a salted hash and never the password, so an inspection based check could never match and would pass silently forever.

Getting Started

1. Launch the image on Standard_B2s or larger 2. Read the per machine credentials from the root only credentials file 3. Run a full-text query in English and in Japanese against the demonstration corpus

Licensing and Pricing

PGroonga is licensed under The PostgreSQL License and is free; there is no per-seat fee. The Groonga library it links is licensed under the GNU Lesser General Public License, and attribution ships inside the image. The cloudimg charge of 0.04 US dollars per vCPU hour covers packaging, security patching, image maintenance and 24/7 expert support. Restrict the database port to your application subnet before you put real data on it.

cloudimg Support

24/7 technical support by email covers deployment, upgrades, index design and tuning. Critical issues receive a one-hour average response.

cloudimg is not affiliated with or endorsed by the PGroonga or Groonga projects. All product and company names are trademarks of their respective holders.