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.
20 Replies
Status changed to Planned jake • over 4 years ago
4 years ago
A nice marketplace and UI, along with being able to manage installed plugins would be awesome as well.
2 years 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
2 years ago
@brody do you have a working dockerfile/nixpack to host pgvector on railway?
2 years ago
Can you link it?
2 years ago
https://railway.app/template/3jJFCA
but what you'd want to do is add it to your existing project via the + New button
2 years ago
Thank you.
2 years ago
hi, can you tell me how to use or migrate pgvector to postgres
2 years 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
2 years ago
2 years 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
9 months ago
any update on this?
7 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
7 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
7 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
Status changed to Completed jake • 4 months ago
Status changed to In Progress ray-chen • 4 months ago
4 months ago
Moving this back to In Progress because what we have only supports extensions that are installed - for third-party extensions such as pgvector, etc. that require additional dependencies/image modifications, they cannot be installed via the UI currently. We'll work on adding support for that 
2 months ago
@ray-chen When do you think this will be ready? I need Postgres with postgis, pgvector and pgcrypto.