pgadmin3 pg_dump does not backup database

Bug #758436 reported by Janny
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
pgadmin3 (Ubuntu)
New
Undecided
Unassigned

Bug Description

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)

Revision history for this message
Janny (janny) wrote :
Revision history for this message
kpistiolis (con) wrote :

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.

Revision history for this message
Guillaume Lelarge (guillaume-lelarge-info) wrote : Re: [Bug 758436] Re: pgadmin3 pg_dump does not backup database

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.