Restoring PostgreSQL Database Backup

From: Muhammad Rizwan Anwar <see2rizwan(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Restoring PostgreSQL Database Backup
Date: 2014-02-07 04:23:07
Message-ID: CABC3gc7_uxAk1ORTnY-pMLfEg10Ra_DNBJ8gquVQcKRXB8Xqww@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Respected,

I am using the following version of PgAdmin and PostgreSQL

PgAdmin Version: 1.8.4 (June 4 2008, rev:7358)
PostgreSQL: 8.3.13

Problem: I have a data base backup file created in PosgtreSQL 8.4.14, when
I restore it in PostgreSQL: 8.3.13 on a database (by using pgadmin-iii,
right click on the data base to restore file) it shows the following error:

D:\PostgreSQL\8.3\bin\pg_restore.exe -h localhost -p 5432 -U postgres -d
aflprod -v "E:\backup af 20140201.backup"
pg_restore: [archiver] unsupported version (1.11) in file header

Process returned exit code 1.

I need help how to handle this issue.

Thanks,

Rizwan

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Craig Ringer 2014-02-07 04:26:35 Re: Restoring PostgreSQL Database Backup
Previous Message Guillaume Lelarge 2014-02-06 18:55:30 Re: Format SQL (external tool)