pgadmin3 pg_dump does not backup database

[Janny]

Binary package hint: pgadmin3

/usr/bin/pg_dump --host servername --port 5432 --username "username" --format custom --blobs --verbose --file "/home/janny/Dropbox/sql_dump/test_20110411.backup" \"DBname\"
pg_dump: [archiver (db)] connection to database ""DBname"" failed: FATAL: database ""DBname"" does not exist
pg_dump: *** aborted because of error

Process returned exit code 1.

problem because of the extra characters -> \" <- to db name
see it this: http://postgresql.1045698.n5.nabble.com/Error-with-pgAdmin-III-backup-restore-td3319910.html

ProblemType: Bug
DistroRelease: Ubuntu 11.04
Package: pgadmin3 1.12.2-1
ProcVersionSignature: Ubuntu 2.6.38-8.42-generic 2.6.38.2
Uname: Linux 2.6.38-8-generic i686
Architecture: i386
Date: Tue Apr 12 07:48:42 2011
InstallationMedia: Ubuntu 11.04 "Natty Narwhal" - Beta i386 (20110330)
ProcEnviron:
 LANGUAGE=hu_HU:en
 LANG=hu_HU.UTF-8
 SHELL=/bin/bash
SourcePackage: pgadmin3
UpgradeStatus: No upgrade log present (probably fresh install)

[kpistiolis (con)]

the dump works for me but I see the same error in restore
OS: Ubuntu 11.04 - the Natty Narwhal - released in April 2011
package: pgadmin3 1.12.2-1

/usr/bin/pg_restore --host localhost --port 5432 --username postgres --dbname \"olap1-2\" --verbose "/home/gus/temp/olapdb-2y4s.backup"
pg_restore: connecting to database for restore
pg_restore: [archiver (db)] connection to database ""olap1-2"" failed: FATAL: database ""olap1-2"" does not exist
pg_restore: *** aborted because of error

Process returned exit code 1.

[Guillaume Lelarge (guillaume-lelarge-info)]

Le 05/13/2011 04:46 PM, kpistiolis a écrit :
> the dump works for me but I see the same error in restore
> OS: Ubuntu 11.04 - the Natty Narwhal - released in April 2011
> package: pgadmin3 1.12.2-1
>
>
> /usr/bin/pg_restore --host localhost --port 5432 --username postgres --dbname \"olap1-2\" --verbose "/home/gus/temp/olapdb-2y4s.backup"
> pg_restore: connecting to database for restore
> pg_restore: [archiver (db)] connection to database ""olap1-2"" failed: FATAL: database ""olap1-2"" does not exist
> pg_restore: *** aborted because of error
>
> Process returned exit code 1.
>

You need pgAdmin 1.12.3.

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