pgvector In Every New PostgreSQL Database
pgvector from AppStream for PostgreSQL 16, created in template1 so every new database starts with it, and in the databases you list. The live test creates a database, finds the extension there, gets the nearest neighbour from an HNSW index the planner uses, and sees a database made from template0 lack the type. Original role, live-tested on Rocky Linux 10.
Verification
Live-testedReally deployed to a container sandbox, proven idempotent (a second run changes nothing), verified against the role’s assertions, then torn down.
Conformance
- Static validation (yamllint · ansible-lint)
Provenance
- SHA-256 checksum
- Signature (pending)
Functional
- Live-tested - applied, verified, destroyed
Last verified 2026-10-02 · podman 4.9.3 · ansible 2.21.4 · how we verify
Cite it in your README
badge · attributionPaste this beside the module in the repository that uses it. The badge is rendered from this artifact's verification record, so it reads live-tested because the record says so, and the link lands on this page.
[](https://www.iac-bazaar.com/catalog/ansible-pgvector?utm_source=syndication&utm_medium=readme&utm_campaign=artifact)
Ansible role 1.0.0, live-tested on IaC Bazaar: [pgvector In Every New PostgreSQL Database](https://www.iac-bazaar.com/catalog/ansible-pgvector?utm_source=syndication&utm_medium=readme&utm_campaign=artifact)
```yaml
# pgvector In Every New PostgreSQL Database: https://www.iac-bazaar.com/catalog/ansible-pgvector (download from your IaC Bazaar account)
```Preview:
Documentation
pgvector
pgvector from AppStream for the distribution's PostgreSQL 16: the extension created in template1, so every new database starts with it, and in any existing databases you list. Original role for EL 10, live-tested with podman on Rocky Linux 10.
AppStream's build, for AppStream's PostgreSQL. EL 10 ships pgvector 0.6.2
for its PostgreSQL 16 (HNSW and IVFFlat indexes); the PostgreSQL 18 stream has
its own postgresql18-pgvector (0.8.0). The role expects the distribution's
postgresql service - this catalogue's postgresql-server role, or yours.
An extension, not a service. The role ensures PostgreSQL runs, then creates the extension where it is missing: in template1 by default, so every database created afterwards has it, and in the databases you list.
Proven by a query. The live test creates a database the way an application would and finds the extension already there (from template1), stores 2,000 random vectors and one known one under an HNSW index, sees the planner use the index, and gets the known row back as the nearest neighbour. A database made from template0, the control, does not have the type.
License
Commercial - IaC Bazaar EULA. (c) IaC Bazaar.
Usage code & full reference need an account
The complete copy-paste usage, the full input/output reference, and operational notes are free with an account - shown here and bundled in the download. Sign in and this section fills in.
- Variables
- Test
Related modules
ansible-clickhouse
ClickHouse on EL 10 from the upstream LTS release (sha512-verified), as a hardened systemd service on loopback with the default user behind a password; the live test creates a MergeTree table, inserts a row and selects it back over HTTP; a query without credentials is refused. Original role, live-tested on Rocky Linux 10.
ansible-dragonfly
Dragonfly on EL 10 from the vendor's release, pinned by a SHA-256 the role carries (the vendor publishes no checksum file), as a hardened systemd service on loopback behind a password kept in a flagfile; the live test speaks RESP itself: an unauthenticated PING and a wrong password are refused, AUTH + SET + GET round-trip. Original role, live-tested on Rocky Linux 10.
ansible-influxdb3
InfluxDB 3 Core on EL 10 from the vendor's release (checksum-verified), as a hardened systemd service on loopback with file object storage; the binary runs from its release directory (it links the Python it ships); the live test writes a point in line protocol and reads it back with SQL. Original role, live-tested on Rocky Linux 10.
ansible-mariadb-server
MariaDB bound to loopback (the package listens everywhere), with the mariadb-secure-installation steps applied by the role: anonymous users, the test database and remote root gone, LOAD DATA LOCAL off, reverse DNS off. Provisions an application database and a user that can see nothing else. Original role, live-tested on Rocky Linux 10.
ansible-meilisearch
Meilisearch on EL 10 from the vendor's release, pinned by a SHA-256 the role carries (the vendor publishes no checksum file), as a hardened systemd service on loopback in production mode behind a master key; the live test creates an index and documents, waits for the indexing task, searches and finds the one match, and sees a keyless request refused. Original role, live-tested on Rocky Linux 10.
ansible-opensearch
OpenSearch 3 (sha512-verified min distribution, bundled JDK), one node on EL 10 from the upstream release, as a hardened systemd service on loopback; the live test reads the root document, indexes one document with a refresh, finds it by a search, deletes the index and checks the keystore belongs to the service; the release tree stays read-only. Original role, live-tested on Rocky Linux 10.