---
title: "Deploy ParadeDB"
description: "One Postgres for app data, BM25 full-text and vector search, pinned"
category: "Storage"
url: https://railway.com/deploy/paradedb-1
---

# Deploy ParadeDB

One Postgres for app data, BM25 full-text and vector search, pinned

**[Deploy ParadeDB on Railway](https://railway.com/template/paradedb-1)**

Machine-readable deploy manifest (JSON, validated by TemplateCI): https://railway.com/deploy/paradedb-1/manifest.json

- **Creator:** Agaz Self-Host
- **Category:** Storage

## Template content

### ParadeDB https://cdn.jsdelivr.net/gh/paradedb/paradedb@v0.26.7/docs/favicon.png

- **Source:** https://github.com/aalfath/paradedb-railway-template
- **Health check:** /healthz

## Documentation

# Deploy and Host ParadeDB on Railway

ParadeDB is PostgreSQL with the open-source `pg_search` extension, which adds BM25 full-text search, fast filters, facets and aggregations. Vector search comes from pgvector in the same database, so application data, keyword search and vector retrieval stay in one Postgres you query with standard SQL and ACID transactions.

## About Hosting ParadeDB

This template runs ParadeDB 0.26.7 on PostgreSQL 18, built from a public GitHub repo that pins the official `paradedb/paradedb` image by version and digest. Data lives on a Railway volume, the superuser password is generated at deploy time, and a health endpoint answers only once Postgres accepts connections. On first start, `pg_search`, `vector`, `postgis`, `pg_ivm` and `pg_stat_statements` are created in the default database and in `template1`. Other services connect over the private network with `DATABASE_URL`, and a TCP proxy with TLS gives `DATABASE_PUBLIC_URL` for tools outside Railway. Version updates arrive as Railway update notices.

## Common Use Cases

* Full-text product, document or support-ticket search with BM25 ranking, without running Elasticsearch next to Postgres
* Hybrid keyword and vector retrieval for AI and RAG applications
* Filtered list views and dashboards with fast counts, facets and aggregations

## Dependencies for ParadeDB Hosting

* None beyond this one service: the image bundles PostgreSQL 18 and the extensions
* A Railway volume for the data directory, created by the template

### Deployment Dependencies

* ParadeDB source and releases: https://github.com/paradedb/paradedb/releases
* ParadeDB documentation: https://docs.paradedb.com/
* Template repo (Dockerfile, start script, changelog): https://github.com/aalfath/paradedb-railway-template

### Implementation Details

Connect from another Railway service with `DATABASE_URL=${{ParadeDB.DATABASE_URL}}`, or from your machine with `psql "$DATABASE_PUBLIC_URL"`. Then create a BM25 index and search:

```sql
CREATE TABLE items (id serial PRIMARY KEY, description text, rating int);
INSERT INTO items (description, rating) VALUES ('Ergonomic metal keyboard', 4), ('Sleek running shoes', 5);
CREATE INDEX items_idx ON items USING bm25 (id, description, rating);
SELECT description, pdb.score(id) FROM items WHERE description ||| 'keyboard' ORDER BY 2 DESC;
```

Memory settings start at `shared_buffers=512MB` and `work_mem=16MB`; change them with `ALTER SYSTEM SET ...` and a redeploy. When you apply a template update, the start script runs `ALTER EXTENSION pg_search UPDATE` for you. Read the repo's `CHANGELOG.md` before applying an update.

## Why Deploy ParadeDB on Railway?


Railway is a singular platform to deploy your infrastructure stack. Railway will host your infrastructure so you don't have to deal with configuration, while allowing you to vertically and horizontally scale it.

By deploying ParadeDB on Railway, you are one step closer to supporting a complete full-stack application with minimal burden. Host your servers, databases, AI agents, and more on Railway.



## Similar templates

- [RustFS | (Just Updated) S3 Object Store, Public URL and Keys Set](https://railway.com/deploy/rustfs-or-just-updated-s3-object-store-p) — S3-compatible object store, keys and public URL preset, volume kept
- [TimescaleDB](https://railway.com/deploy/timescaledb-railway-template) — A PostgreSQL-based time-series database for analytics on Railway.
- [Neo4j 2026.10 Community](https://railway.com/deploy/neo4j-202610-community) — Neo4j graph database with APOC, Browser, Bolt TCP proxy and a volume

Open this page in a browser: https://railway.com/deploy/paradedb-1
