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?
>