
PostgreSQL to Meilisearch Sync
A quick setup for syncing data from PostgreSQL to Meilisearch
Postgres DB
nMessage/Meilisync-on-railway
Just deployed
/var/lib/postgresql/data
Meilisync-on-railway
nMessage/Meilisync-on-railway
Just deployed
Railway Template: Meilisync Integration
This template provides a streamlined setup for integrating PostgreSQL with a Meilisearch instance using Meilisync for data synchronization. It is designed for straightforward configuration, enabling a quick connection between a PostgreSQL database and Meilisearch without extra dependencies like an admin-dashboard or Redis for progress tracking.
Key Features:
- Configurable Setup: Modify the configuration file located at
/sync/config.yml
in GitHub to adjust synchronization parameters for specific data and indexing needs. - Indexing with Meilisearch: Ensures that the target index is created and synchronized in the connected Meilisearch service or instance using Meilisync
- Database Compatibility: Includes PostgreSQL pre-requisites, based on Railways PostgreSQL 16 with SSL Template
- Bring Your Own Meilisearch Instance: This template requires an existing Meilisearch instance, so users will need to connect their own service.
Setup Instructions:
-
Configure: Follow the setup instructions from Meilisync's GitHub repository to configure and verify the setup.
-
Verify: Ensure that the required table exists in PostgreSQL and that
/sync/config.yml
is correctly configured for synchronization requirements. You might get a strange error & service crash if this is not done.
Additional Information
For more details on using templates and deploying services on Railway, see Railway's Documentation. To modify the config.yml
file for Meilisync, consider ejecting the repository under settings.
This template is a straightforward setup for synchronizing PostgreSQL data with Meilisearch while utilizing Railway’s deployment infrastructure. Hope you enjoy!
Template Content
Postgres DB
nMessage/Meilisync-on-railwayPOSTGRES_DB
The name of the DATABASE you are using.
Meilisync-on-railway
nMessage/Meilisync-on-railwayPK_1
ID Key of TABLE_1
INDEX_1
The name of Meilisearch index. (https://www.meilisearch.com/docs/reference/api/indexes)
TABLE_1
The PostgeSQL Table (or View) of data to sync into Meilisearch INDEX_1
MEILISERCH_ADMIN_API_KEY
The ADMIN key of your Meilisearch service