Loading...

Install Postgres Extensions

Anonymous

TRIAL

4 years ago

The default Postgres extensions are great, and provide a lot of functionality that makes the Railway hosted version much more useful than a vanilla Postgres install. With that said, there are some additional extensions that are useful in some use cases, but may not be as widely needed as the default extensions. Are there any plans to allow for additional extensions to be installed? Even allowing extensions just from very well-known and trusted developers (ex: https://github.com/citusdata/pg_cron) would be very helpful.

Planned

16 Replies

Status changed to Planned jake • almost 4 years ago

milo

MODERATOR

3 years ago

A nice marketplace and UI, along with being able to manage installed plugins would be awesome as well.

lassegit

HOBBY

a year ago

What is the status on this? Looking to add pgvector to existing Postgres.

brody

EMPLOYEE

a year ago

as far as I can tell is not on the horizon, I would recommend deploying a pgvector database, backing up your old database and restoring it to the new pgvector database

maskos

HOBBY

a year ago

@brody do you have a working dockerfile/nixpack to host pgvector on railway?

brody

EMPLOYEE

a year ago

there is already a pgvector template

maskos

HOBBY

a year ago

Can you link it?

brody

EMPLOYEE

a year ago

https://railway.app/template/3jJFCA

but what you'd want to do is add it to your existing project via the + New button

maskos

HOBBY

a year ago

Thank you.

maximobatallan

HOBBY

a year ago

hi, can you tell me how to use or migrate pgvector to postgres

brody

EMPLOYEE

a year ago

you can use the Postgres Plugin Migration template where the PLUGIN_URL is the pgvector database URL and the NEW_URL is the postgres database URL

lassegit

HOBBY

a year ago

This is how I did it: https://www.sqlai.ai/posts/migrate-postgresql-database-using-logical-replication-and-downtime-close-to-zero

maximobatallan

HOBBY

a year ago

thanks for the answer, when i config the variables the migration try to deploy but its crash and i have the next issue: failed: FATAL: database "railway/postgres" does not exist

thejufo

FREE

4 months ago

any update on this?

atternatt

HOBBY

2 months ago

I just found one template with PostGIS + TimescaleDB and another with PGVector. What If I need one with the three all together? PostGIS + Timescale + PGVector? cc @brodi

brody

you can use the `Postgres Plugin Migration` template where the `PLUGIN_URL` is the pgvector database URL and the `NEW_URL` is the postgres database URL

atternatt

HOBBY

2 months ago

sorry didn't saw the reply feature before submitting, readding it now:
I just found one template with PostGIS + TimescaleDB and another with PGVector. What If I need one with the three all together? PostGIS + Timescale + PGVector? cc @brodi

jamesmeneghello

PRO

2 months ago

The answer to all of these questions is the same: use a custom Docker image. Example of pgssl16+wal2json here: https://github.com/dusc-dev/postgres-ssl-wal2json/blob/main/Dockerfile.pg16