Thread: A couple of bugs...
Hello, There are a couple of bugs surrounding backup/restore. When you go to backup it doesn't just work - I haven't played around with settings. On the command line it suggest that it's tried: pg_dump... -F -p ... Where what it should generate is: pg_dump... -F p ... Worse, you can't copy and paste the command line because the cursor keeps dipping down to the next line. With restore, you select the file to restore, but the OK button remains greyed out. Thanks, David.
On Thu, Mar 19, 2009 at 9:08 AM, David Gould <david@networkltd.eu> wrote: > Hello, > > There are a couple of bugs surrounding backup/restore. > > When you go to backup it doesn't just work - I haven't played around with > settings. On the command line it suggest that it's tried: > > pg_dump... -F -p ... > > Where what it should generate is: > > pg_dump... -F p ... As far as I can see in the source history it's been hardcoded to -F p since the code was written in 2004: cmd.Append(wxT(" -F p")); It was changed for 1.10, but it uses the long command options now so you'll see --format not -F. What version of pgAdmin are you using? > Worse, you can't copy and paste the command line because the cursor keeps > dipping down to the next line. Works fine for me. What platform are you on? > With restore, you select the file to restore, but the OK button remains > greyed out. That'll happen if you select a file that isn't a valid dump file recognised by pg_restore. Note that PLAIN dumps must be restored using psql manually. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
Thanks for your prompt response.<br /><br /> I am currently running pgAdmin 1.8.4 on Vista for backup and XP for restore. Server is 8.3.6 on the local machine in both cases.<br /><br /> Dave Page wrote: <blockquote cite="mid:937d27e10903190243h5057f261tb03a29f3bce9e33@mail.gmail.com"type="cite"><pre wrap="">On Thu, Mar 19, 2009 at 9:08AM, David Gould <a class="moz-txt-link-rfc2396E" href="mailto:david@networkltd.eu"><david@networkltd.eu></a> wrote:</pre><blockquote type="cite"><pre wrap="">Hello, There are a couple of bugs surrounding backup/restore. When you go to backup it doesn't just work - I haven't played around with settings. On the command line it suggest that it's tried: pg_dump... -F -p ... Where what it should generate is: pg_dump... -F p ... </pre></blockquote><pre wrap=""> As far as I can see in the source history it's been hardcoded to -F p since the code was written in 2004: cmd.Append(wxT(" -F p")); It was changed for 1.10, but it uses the long command options now so you'll see --format not -F. What version of pgAdmin are you using? </pre></blockquote> Sorry, I am mistaken it seems to becorrect now.<br /><br /> What actually happens is that when you enter the backup window and click "OK" it flicks over tothe Messages screen, but nothing happens. A backup file appears but it's 0 bytes in length.<br /><blockquote cite="mid:937d27e10903190243h5057f261tb03a29f3bce9e33@mail.gmail.com"type="cite"><pre wrap=""> </pre><blockquote type="cite"><prewrap="">Worse, you can't copy and paste the command line because the cursor keeps dipping down to the next line. </pre></blockquote><pre wrap=""> Works fine for me. What platform are you on? </pre></blockquote> I hold down shift, press up-arrow and it flicks down. Thisis on 1.8.4 on the Vista platform.<br /><blockquote cite="mid:937d27e10903190243h5057f261tb03a29f3bce9e33@mail.gmail.com"type="cite"><blockquote type="cite"><pre wrap="">Withrestore, you select the file to restore, but the OK button remains greyed out. </pre></blockquote><pre wrap="">That'll happen if you select a file that isn't a valid dump file recognised by pg_restore. Note that PLAIN dumps must be restored using psql manually.</pre></blockquote> Yes, thanks for this - I've discovered that! Probably a frequent first mistake.<br /><br/> Thanks<br /><br /> David.<br />
On Thu, Mar 19, 2009 at 10:46 AM, David Gould <david@networkltd.eu> wrote: > What actually happens is that when you enter the backup window and click > "OK" it flicks over to the Messages screen, but nothing happens. A backup > file appears but it's 0 bytes in length. It sounds like it's starting the backup. Does the button text change to 'Done' at some point? > Worse, you can't copy and paste the command line because the cursor keeps > dipping down to the next line. I don't see that behaviour on Vista here. I can imagine it would happen if you were horizontally scrolled to the right, and the backup was outputing text that wasn't wide enough be be on that are of the screen (the scrollbar is sized by the command at the beginning which is normally much wider than the rest of the output. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com