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
Solution:Jump to solution
asked someone else on the team who was involved, this should be the command you need
...
27 Replies
Project ID:
N/Awhen 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
Solution
asked someone else on the team who was involved, this should be the command you need
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 "_timescaledb_catalog.chunk_id_seq" 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!