How do I restore a plain text postgres .backup file 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?
run:

psql -U your_user_name your_db_name &lt; your_dump_file