pgvector-pg18
-ok-
PROOP

4 months ago

Description: PostgreSQL 18 with powerful vector search support.

Category: Storage

URL: https://railway.com/deploy/pgvector-pg18

4 Replies

tipper-network
HOBBY

3 months ago

hi hi.
i wanted to ask a few questions. when deploying this i get a pgvector , but i i cant seem to have access to the db.
the postgres db i have comnes with a ui while the pgvector ones dont.
any advice on how to be able to access my db? is it thorugh docker or dbeaver or pgadmin ??
would like the input


tipper-network

hi hi. i wanted to ask a few questions. when deploying this i get a pgvector , but i i cant seem to have access to the db. the postgres db i have comnes with a ui while the pgvector ones dont. any advice on how to be able to access my db? is it thorugh docker or dbeaver or pgadmin ?? would like the input

-ok-
PROOP

3 months ago

Hi

When deploying this, you should get a single service called pgvector.

This is a postgresql 18 instance which has the pgvector extension installed.
When you click on the service instance, you should see a tab called Variables - and clicking that should show you all the variables you need to connect to the database.

For instance, the public URL is stored in the variable: DATABASE_PUBLIC_URL
This should have a value like: postgresql://[username]:[password]@[host]:[port]/[db-name]
(There are other variables that you can refer to as well)

Using the info provided here, it should be possible for you to connect to the DB from any postgres client (yes, dbveaver, pgadmin etc should work fine)

Hope that helps.
Cheers!


-ok-

HiWhen deploying this, you should get a single service called pgvector.This is a postgresql 18 instance which has the pgvector extension installed.When you click on the service instance, you should see a tab called Variables - and clicking that should show you all the variables you need to connect to the database.For instance, the public URL is stored in the variable: DATABASE_PUBLIC_URLThis should have a value like: postgresql://[username]:[password]@[host]:[port]/[db-name](There are other variables that you can refer to as well)Using the info provided here, it should be possible for you to connect to the DB from any postgres client (yes, dbveaver, pgadmin etc should work fine)Hope that helps.Cheers!

tipper-network
HOBBY

2 months ago

that means i will not really need to have the postgres db on railway. or i can connect to that ( the one i already have) ?


tipper-network

that means i will not really need to have the postgres db on railway. or i can connect to that ( the one i already have) ?

-ok-
PROOP

2 months ago

Yes - that's right, you don't need a separate postgres db on railway.
It might be helpful to check out the docs here.


Loading...