Re: database name quoted error in backup command.

On 04/28/2011 04:33 PM, yangjun wrote:
> pgadmin ver 1.12.2 on windows
> when backup a database name 19
> the backup command log show as below:
> I:/PostgreSQL/9.0/bin\pg_dump.exe --host localhost --port 9007 --username
> "postgres" --format custom --blobs --verbose --file "r:\test.backup" \"19\"
> pg_dump: [archiver (db)] connection to database ""19"" failed: FATAL:
> database ""19"" does not exist
> pg_dump: *** aborted because of error
>
> Process returned exit code 1.
> -------------------------------------------------------------------------
> two command below run fine.
> I:/PostgreSQL/9.0/bin\pg_dump.exe --host localhost --port 9007 --username
> "postgres" --format custom --blobs --verbose --file "r:\test.backup" "19"
> or
> I:/PostgreSQL/9.0/bin\pg_dump.exe --host localhost --port 9007 --username
> "postgres" --format custom --blobs --verbose --file "r:\test.backup" 19
>

Upgrade to 1.12.3, it has has a fix for this issue.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com