Thread: Problem restoring backup file

I am using PGSQL 8.2.3. I took a backup of my database selecting "Plain" option from pgAdmin 1.6. When I am trying to
restoreit to a new machine having PGSQL 8.2.3 installed, using pgAdmin, the OK button of the "Restore Backup Window"
remainsdisabled. Why? <br /><br /> 

Hi.

Please see,
http://www.pgadmin.org/docs/1.6/backup.html

pg_dump does not support all options for all backup file formats. Particularly, to backup 
blobs the PLAIN format can not be used. Also, a PLAIN file can not be interpreted, and 
can not be restored using pgAdmin. The PLAIN format will create an SQL script that can 
be executed using the psql tool. For standard backup and restore purposes, the COMPRESS 
and TAR options are recommended.

Regards,
Hiroshi Saito

----- Original Message ----- 
From: "Rohit Khare" <rpk.general@gmail.com>
To: <pgadmin-support@postgresql.org>
Sent: Monday, April 02, 2007 2:19 PM
Subject: [pgadmin-support] Problem restoring backup file


>I am using PGSQL 8.2.3. I took a backup of my database selecting "Plain"
> option from pgAdmin 1.6. When I am trying to restore it to a new machine
> having PGSQL 8.2.3 installed, using pgAdmin, the OK button of the "Restore
> Backup Window" remains disabled. Why?
>