Обсуждение: 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