Обсуждение: database name quoted error in backup command.
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
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
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
杨军
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