when you where given your archive file, where you given a command to run to restore it?

no

please ask them for the correct command needed to restore the database

they closed the thread 😉

fair enough

i fill like i am missing something

I am missing something too, I don't know what command their automated process ran to create that dump, so I would only be guessing at the command needed to restore it

do you remember who you talked to?

Christian Ohrgaard

I assume you where emailed the file?

yes, i was provided with links

in support thread

okay, so the person who was responsible for creating the dumps is on DND right now so I'm not going to ask them, until they are off DND, keep trying to restore the dump file with different formatted commands. what file extension was your dump file provided with?

.tar.gz

have you tried restore commands that are compatible with tarballs?

inside two files postgres.sql and railway.sql

i thought the one i am using is compatible:)

seems it's not

asked someone else on the team who was involved, this should be the command you need

psql $url_to_restore_to -f file.sql

thanks it seems to have done something, and i see some data created in db but during execution it threw me a banch of error like: psql:/railway.sql:1952: ERROR: relation "timescaledbcatalog.chunkidseq" does not exist

did you use timescale features of your legacy database?

i do not know

is this not your app?

it is mine, but i never heard about timescale

then you definitely didn't use it

so check to see if all your data is there

this database was used as db for strapi cms, if it makes sence

yep I know about strapi, it would not have used timescale features

looks like it is working, strapi running without problems on restored db. thank you for your help

awesome!