How do I restore a plain text postgres .backup file run: psql -U your_user_name your_db_name < your_dump_file