up vote 1 down vote favorite
share [g+] share [fb]

I exported a postgres db from pgAdmin in a plain format because I wanted to search the whole db text. I then tried to restore the database back but it gives an error saying that the archive file is not valid archive file. How do I restore the db back if it can be restored?

link|improve this question
feedback

migrated from stackoverflow.com Feb 21 at 16:57

This question came from our site for professional and enthusiast programmers.

1 Answer

up vote 1 down vote accepted

run:

psql -U your_db_name your_db_name < your_dump_file
link|improve this answer
I am on windows 7. Can I do this on windows 7? – yankitwizzy Feb 21 at 11:09
it should, if psql frontend is included in the postgresql package. Try to fire up a terminal, then cd to postgresql bin directory and try to run psql – guido Feb 21 at 11:13
I tried it now. It didnt work. There is psql.bat file in the postgres bin directory. I am using postgres 8.3 – yankitwizzy Feb 21 at 11:17
what do you mean with 'it didnt work'? if there is psql.bat however, try with that, it should run psql. look here for help archives.postgresql.org/pgsql-admin/2006-12/msg00091.php – guido Feb 21 at 11:22
Sorry I meant there is no psql.bat file in the bin directory – yankitwizzy Feb 21 at 11:27
show 1 more comment
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.