I've run into an issue with the default backup/restore of a database in pgAdmin (the one bundled with PostgreSQL
9.02). I am currently running Version 1.12.2 (Dec 14 2010, rev: REL-1_12_2) on PostgreSQL 9.02. The issue has occurred
forme on Windows 7 Ultimate (32-bit) and Windows Server 2003 (32-bit R2 Service Pack 2).<br /><br />The error occurs
whenI try to backup either one of my PostGIS databases with the default options selected.<br />Format: COMPRESS (No
CompressRatio or Encoding specified)<br />Dump Options #1: Only "Blobs" is checked<br /> Dump Options #2: Only "Verbose
messages"is checked<br />Objects: All objects are selected (Database, schema, and all tables)<br /><br />My database
namescontain no quotes or special characters other than a single underscore (example: Test_Exits, Test_GIS, etc.)<br
/><br
/>------------------------------------------------------------------------------------------------------------------<br
/>Theerror message I receive when trying to backup is the following:<br /><br
/>C:/Applications/PostgreSQL/9.0/bin\pg_dump.exe--host localhost --port 5432 --username "postgres" --format custom
--blobs--verbose --file "C:\Applications\Test.backup" \"Test_Exits\"<br /> pg_dump: [archiver (db)] connection to
database""Test_Exits"" failed: FATAL: database ""Test_Exits"" does not exist<br />pg_dump: *** aborted because of
error<br/><br />Process returned exit code 1.<br />
------------------------------------------------------------------------------------------------------------------<br
/><br
/>------------------------------------------------------------------------------------------------------------------<br
/>The error message I receive when trying to restore is the following:<br /><br
/>C:/Applications/PostgreSQL/9.0/bin\pg_restore.exe--host localhost --port 5432 --username postgres --dbname
\"Test_Exits\"--verbose "C:\Applications\OpenTMS_Exits.backup"<br /> pg_restore: connecting to database for restore<br
/>pg_restore:[archiver (db)] connection to database ""Test_Exits"" failed: FATAL: database ""Test_Exits"" does not
exist<br/>pg_restore: *** aborted because of error<br /><br />Process returned exit code 1.<br
/>------------------------------------------------------------------------------------------------------------------<br
/><br/>It seemed obvious to me that the escape characters ( \ ) before the double quotes caused the issue. Running the
commandsin the psql shell without the two backslashes around the database name caused both the backup and restore to
workproperly. I'm wondering if this issue was introduced by the change made for <a
href="http://code.pgadmin.org/trac/ticket/266">Ticket#266</a>?<br/>