Re: PgAdmin V 1.16.1 Error - Comment on database

Hello,

Gesendet: Freitag, 02. August 2013 um 19:45 Uhr
Von: "Dave Page"
Betreff: Re: [pgadmin-support] PgAdmin V 1.16.1 Error - Comment on database
On Thu, Aug 1, 2013 at 12:13 PM, Jan-Peter Seifert

> > backups:
> > -you don't see which database/schema is being dumped anymore - you have
> > to remember to verify that all objects from the correct database are
> > being dumped in the objects tab.

> You'll have to explain that one. We display the pg_dump command and
> output, which includes any database/schema names that the dump is
> restricted to. The output from pg_dump is not something we control
> though.

I've attached the dialogue from 1.12.3.
The windows bar says 'Backup Database postgres'.
Format 'Compress' is automatically selected.

The windows bar in 1.14.3. and 1.16.1 is blank.
No format is selected so the dump is always plain text by default.

> > -backups on Windows 7 still take a much longer time than calling pg_dump
> > from command line. This has been the case since 1.12 though ...

> I have no idea why or how that could be the case, and it's not
> something I've heard elsewhere. Do you use the exact same command in
> both cases?

Someone else mentioned this in his reply when I reported this the first time.
I guess it does not happen if you use a Windows version older than Windows 7 ...

With pgAdmin 1.16.1 it took over 10 minutes to dump the database.

I copied the command from pgAdmin ( had to add double quotes because of the blank in the path ):

"C:\Program Files\PostgreSQL\9.2\bin\pg_dump.exe" --host localhost --port 5492 --username "postgres" --no-password --verbose --file "D:\1.backup" "database"

This took ~ 2:20 minutes in the command line ...

No problems with using pgAdmin 1.10.5 and pg_dump 9.2.4 either.

The only real difference I see is that the user and the database have no double quotes and that '--no-password' is not being used in 1.10.5:
"C:\Program Files\PostgreSQL\9.2\bin\pg_dump.exe" --host localhost --port 5432 --username postgres --format plain --verbose --file "D:\2.backup" database

It happens on Windows 7 64 bit and 32 Bit.

No luck with deactivating virus scanners and Aero.

Same behavior in Windows XP Mode ...

With best regards,

Peter