http://kb.owrench.com/index.php?action=history&feed=atom&title=Backup_restore_issues 2026-05-04T04:27:06Z Revision history for this page on the wiki MediaWiki 1.34.2 http://kb.owrench.com/index.php?title=Backup_restore_issues&diff=101&oldid=prev 2017-06-27T10:31:18Z

<p>Created page with &quot;Postgres databases are mostly backed up in the format tar and there won&#039;t be any issues in restoring them under normal circumstances.&lt;br&gt; &lt;b&gt;Error: 1 ,&lt;/b&gt; when the pg_restor...&quot;</p> <p><b>New page</b></p><div>Postgres databases are mostly backed up in the format tar and there won't be any issues in restoring them under normal circumstances.&lt;br&gt;<br /> <br /> &lt;b&gt;Error: 1 ,&lt;/b&gt; when the pg_restore command is run, it will throw &quot;unsupported version&quot; error. &lt;br&gt;<br /> &lt;br&gt;<br /> In this case, please verify if the postgres version of the source(remote) server and the target(local) server are the same. &lt;br&gt;<br /> If the versions are different, tar(custom) formats will not be supported (there is backward compatibility though). &lt;br&gt;<br /> &lt;br&gt;<br /> <br /> Resolution: &lt;br&gt;<br /> 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 &lt;br&gt;<br /> &lt;br&gt;<br /> <br /> &lt;b&gt;Error: 2 &lt;/b&gt;, connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host localhost&lt;br&gt;<br /> Add or edit the following line in your postgresql.conf :&lt;br&gt;<br /> <br /> listen_addresses = '*'&lt;br&gt;<br /> <br /> Or you can try changing the restore command by providing localhost instead of 127.0.0.1 as argument. &lt;br&gt;<br /> <br /> [[Category:it-support]]</div>

imported>Kishor