Restore Plain Text Postgres .backup File – How to Guide

pgadminpostgresql

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?

Best Answer

run:

psql -U your_user_name your_db_name < your_dump_file

Related Solutions

Postgresql – How to solve UTF8 invalid byte sequence copy errors on a restore, when the source database is encoded in UTF8

Digging around the internet, I've seen that this is a pretty common problem. The common solution is to use the plain text format dump and feed it through iconv to correct the encoding.

Here is more information about that.

Postgresql – Error importing back a postgres db after dumping

The problem is that you cannot COPY FROM stdin with pgAdmin (no stdin available in the query window), but you can easily restore the dump with psql

psql <database> -h <host> -p <port> -f <dump-file>

Hope that helps.

Best Answer

Related Solutions

Postgresql – How to solve UTF8 invalid byte sequence copy errors on a restore, when the source database is encoded in UTF8

Postgresql – Error importing back a postgres db after dumping

Related Question