Index: index.php
===================================================================
RCS file: /projects/www/pgadmin3/faq/index.php,v
retrieving revision 1.13
retrieving revision 1.14
diff -Lpgadmin3/faq/index.php -Lpgadmin3/faq/index.php -u -w -r1.13 -r1.14
--- pgadmin3/faq/index.php
+++ pgadmin3/faq/index.php
@@ -11,6 +11,7 @@
User privileges
Foreign key constraints not shown
Problem after changing column type
+Can't restore backup file created with pgAdmin III
ERROR: column "datpath" does not exist
Win9x problems
Query tool hangs on Win9x
@@ -88,6 +89,19 @@
have to do that manually if you encounter execution errors. pgAdmin III V1.3 and later are planned to do
that automatically. This is not necessary on PostgreSQL 8.+ servers, because these versions support altering
a column type instrinsically.
+
+I created a backup file using pgAdmin III, but when I try to restore it using pgAdmin III +the OK button will stay grayed. +
+pgAdmin III uses PostgreSQL's pg_restore tool, which supports only the COMRESS and TAR options of pg_dump +which is used for backup creation. The PLAIN format can't be interpreted by pgAdmin III and pg_restore +(it can be edited manually, and executed with psql and pgAdmin III's query tool in many cases), and thus +isn't accepted as valid file. ++We recommend using the COMPRESS format for daily backup tasks. The PLAIN format is for advanced manual +processing before executing as SQL script, and has some restrictions (no blobs) which makes it less usable +for standard backup tasks.