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. +

Can't restore backup file created with pgAdmin III

+

+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.


ERROR: column "datpath" does not exist