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:)