How do I restore a plain text postgres .backup file

Question

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?

score 27 · Accepted Answer · edited Jul 08 '14 at 07:51

27

run:

psql -U your_user_name your_db_name < your_dump_file

edited Jul 08 '14 at 07:51

Community

1

answered Feb 21 '12 at 11:07

guido

386
3
7

How do I restore a plain text postgres .backup file

1 Answers1

Linked