Backup restore issues

From Origami_Wiki
Revision as of 16:01, 27 June 2017 by imported>Kishor (Created page with "Postgres databases are mostly backed up in the format tar and there won't be any issues in restoring them under normal circumstances.<br> <b>Error: 1 ,</b> when the pg_restor...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Postgres databases are mostly backed up in the format tar and there won't be any issues in restoring them under normal circumstances.

Error: 1 , when the pg_restore command is run, it will throw "unsupported version" error.

In this case, please verify if the postgres version of the source(remote) server and the target(local) server are the same.
If the versions are different, tar(custom) formats will not be supported (there is backward compatibility though).

Resolution:
Use the plain text format instead of custom formats for pg_dump and pg_restore commands. The usage of these commands are explained in the following page: http://192.168.1.103/mediawikisb/index.php/Postgres_basics

Error: 2 , connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host localhost
Add or edit the following line in your postgresql.conf :

listen_addresses = '*'

Or you can try changing the restore command by providing localhost instead of 127.0.0.1 as argument.

Retrieved from "http://kb.owrench.com/index.php?title=Backup_restore_issues&oldid=101"