kiryl_ch

Explore posts from servers

RRailwayTtRPCDTDrizzle TeamKKinde

PostsComments

RRailway

•Created by kiryl_ch on 4/28/2024 in #✋｜help

can i use railway postgres db with @vercel/postgres ?

I am try trying to use railway postgress db with @vercel/postgres. Is it compatible? How do I map railway variables to required vercel env varaibles?

19 replies

RRailway

•Created by kiryl_ch on 3/20/2024 in #✋｜help

gen_random_uuid not working

hi. I am trying to use postgress db provisioned on railway with drizzle. my schema look like id: uuid('id').default(sql'gen_random_uuid()') but on insert into this db I get error PostgresError: null value in column "id" of relation "file" violates not-null constraint is it possible that my db does not have this function? if so what should I do to create column with autogenerated uuid ? thanks!

5 replies

RRailway

•Created by kiryl_ch on 3/6/2024 in #✋｜help

how to restore postgres db from dumb?

i was given my db archives because my db was deleted due to migration. I am trying to restore the db data by running this command pg_restore -U <username> -h <host> -p <port> -W -F t -d <db_name> <dump_file_name> but I am getting error pg_restore: error: could not find header for file "toc.dat" in tar archive

33 replies