abb46987-3c03-44a4-9717-c0ad17b59a6f

you would want to deploy the pgvector template into your account, and then pgbackup the old database, and pgrestore to the new database

is there are any blog or any guide video so it will help me a lot

i'm sure there are plently of articles out there on how to use pgbackup and pgrestore that would help you, they would be just a quick online search away

how to do that in fresh new database

I have explored some options but didn't understand properly

are you asking how to deploy pgvector?

yes

I have deployed but when I am using this command then it saying

railway=# SELECT * FROM pgavailableextensions WHERE name = 'vector';
name | defaultversion | installedversion | comment
------+-----------------+-------------------+---------
(0 rows)

open up your project, click the + Create button at the top right, choose template, search for "pgvector", then click deploy template

you have a regular database deployed, you need to deploy pgvector first

give this page a read -

then follow the steps i have provided

I have added the template in my postgres database

but still getting this issue:

railway=# CREATE EXTENSION IF NOT EXISTS vector;
ERROR: extension "vector" is not available
DETAIL: Could not open extension control file "/usr/share/postgresql/16/extension/vector.control": No such file or directory.
HINT: The extension must first be installed on the system where PostgreSQL is running.

check this

you need to connect to the pgvector database

how?

the same way you connect to Postgres

like this?

?

?

Done!

thanks

solved

!s