Обсуждение: database name quoted error in backup command.

Поиск
Список
Период
Сортировка

database name quoted error in backup command.

От
"yangjun"
Дата:
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
 
yangjun
杨军
 

Re: database name quoted error in backup command.

От
Guillaume Lelarge
Дата:
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.


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com