Thread: Bug -PGAdmin 1.12.2
<font face="Courier New">O/S - Windows XP Service Pack 3<br /> Language - English<br /> Distribution - binary (.zip)<br />Version you tested 1.12.2<br /><br /> Bug:<br /> Attempting to backup a CamelCase named database (eg: MyDataBase) failswith <br /> C:\Program Files\pgAdmin III\1.12\pg_dump.exe --host 172.26.15.104 --port 5432 --username "mdavidson" --formatcustom --blobs --verbose <br /> --file "C:\PostgreSQL\backups\x.backup" \"ICSPayments\"<br /> pg_dump: [archiver(db)] connection to database ""</font><font face="Courier New">MyDataBase</font><font face="Courier New">"" failed:<font color="#cc0000"><b>FATAL: database ""</b></font></font><font color="#cc0000"><b><font face="Courier New">MyDataBase</font></b></font><fontface="Courier New"><font color="#cc0000"><b>"" does not exist</b></font><br /> pg_dump:*** aborted because of error<br /><br /> Process returned exit code 1.<br /></font><br /><b>Backing up a databasethat is all lowercase succeeds.</b><br /><br /><div class="moz-signature"><img border="0" src="cid:part1.09060504.02050907@icsolutions.com"/></div>
Le 10/02/2011 22:12, Melvin Davidson a écrit : > O/S - Windows XP Service Pack 3 > Language - English > Distribution - binary (.zip) > Version you tested 1.12.2 > > Bug: > Attempting to backup a CamelCase named database (eg: MyDataBase) fails with > C:\Program Files\pgAdmin III\1.12\pg_dump.exe --host 172.26.15.104 --port 5432 > --username "mdavidson" --format custom --blobs --verbose > --file "C:\PostgreSQL\backups\x.backup" \"ICSPayments\" > pg_dump: [archiver (db)] connection to database ""MyDataBase"" failed: *FATAL: > database ""**MyDataBase**"" does not exist* > pg_dump: *** aborted because of error > > Process returned exit code 1. > > *Backing up a database that is all lowercase succeeds.* > This is already fixed. It'll be available in the next minor release. Thanks for your report. -- Guillaumehttp://www.postgresql.frhttp://dalibo.com
Le 10/02/2011 22:37, Melvin Davidson a écrit : > Guillaume, > > Thank you very much for your reply and contributions to PgAdmin! > You're welcome. > FYI, In further testing of the backup, selective object backup is ignored, > (options tab of backup) and all objects are backed up regardless. > Works for me here. What are your exact steps? -- Guillaumehttp://www.postgresql.frhttp://dalibo.com
<pre wrap="">>Works for me here. What are your exact steps?</pre> Steps to duplicate:<br /><br /> 1. Right Click on adatabase<br /> 2. Click on Backup<br /> 3. In popup screen, specify filename.<br /> 4. Click the Objects Tab<br /> 5. Uncheckthe database (1st box)<br /> 6. Specifically check two or more individual tables, but not all.<br /> 7. Click OK <br/><br /> Poof! All tables are copied, regardles of whether they are checked or not.<br /><br /><blockquote cite="mid:4D641EDE.20307@lelarge.info"type="cite"><blockquote type="cite"><pre wrap="">FYI, In further testing of the backup,selective object backup is ignored, (options tab of backup) and all objects are backed up regardless. </pre></blockquote><pre wrap=""> Works for me here. What are your exact steps? </pre></blockquote><br /><br /><div class="moz-signature">-- <br /><img border="0" src="cid:part1.05010004.00040808@icsolutions.com"/></div>
Le 22/02/2011 23:37, Melvin Davidson a écrit : >> Works for me here. What are your exact steps? >> >> Steps to duplicate: >> >> 1. Right Click on a database >> 2. Click on Backup >> 3. In popup screen, specify filename. >> 4. Click the Objects Tab >> 5. Uncheck the database (1st box) >> 6. Specifically check two or more individual tables, but not all. >> 7. Click OK >> OK. As soon as you unchecked the database checkbox or a schema checkbox, nothing below the checkbox is checked. Not sure what the correct fix should be. I was thinking that once you click on a table, pgAdmin should check that the schema is checked and that the database is checked too. And check them if they aren't. What do you think? -- Guillaumehttp://www.postgresql.frhttp://dalibo.com
Le 23/02/2011 23:49, Melvin Davidson a écrit : > Guillaume, > > True, nothing below the database or schema checkbox was checked, > but to me, that should not matter. The command line should be altered to use the > individual -t flag > for the tables that are then checked. > > Perhaps a final check of "No Objects Selected" should disable the OK button? > I fixed this another way. Once you click on a table, the schema and the database are automatically checked, so that you don't have to care about it. Thanks for your report. -- Guillaumehttp://www.postgresql.frhttp://dalibo.com