Re: 1.12.1 - cannot dump from older server versions

Hello,

-------- Original-Nachricht --------
> Datum: Mon, 03 Jan 2011 13:30:27 +0100
> Von: Jan-Peter(dot)Seifert(at)gmx(dot)de
> An: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
> CC: pgadmin-support(at)postgresql(dot)org
> Betreff: Re: [pgadmin-support] 1.12.1 - cannot dump from older server versions

> Hello and Happy New Year!
>
> -------- Original-Nachricht --------
> > Datum: Wed, 08 Dec 2010 15:39:59 +0100
> > Von: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
> > An: Jan-Peter Seifert <Jan-Peter(dot)Seifert(at)gmx(dot)de>
> > CC: pgadmin-support(at)postgresql(dot)org
> > Betreff: Re: [pgadmin-support] 1.12.1 - cannot dump from older server
> versions
>
> > Le 07/12/2010 10:45, Jan-Peter Seifert a écrit :
> > > Hello,
> > >
> > > I have problems dumping databases on older server versions (e.g. 8.4)
> > with pgAdmin 1.12.1. It seems to enter an endless loop after clicking
> 'OK'.
> > It doesn't matter whether the binaries path points to v8.4 or v9.0.
> Dumping
> > from 9.0 works fine.
> > > I have 8.3 (pg_installer, two instances/services), 8.4 and 9.0
> installed
> > on Windows xp.
> > >
> >
> > Do you have any error message? I have no issue with the dump/restore
> > facility with 1.12 release.
>
> Sorry for replying this late. I've tested it with 1.12.2 on a different
> system again (Windows 7, 64-Bit). The issue is still there. After starting
> the backup parts of the desktop are being refreshed rapidly - not just the
> pgAdmin and the backup dialogue window. Even the mouse cursor and the icon of
> another running program in the task bar 'flashed' after starting the
> backup and switching the active window. The backup eventually completes, but
> takes much longer for the same database on a 8.4 server - about a minute
> instead of 8 seconds when using pgAdmin 1.10.5. Could check this again, please?
>
> Thank you very much,
>
> Peter

Hello,

somehow this seems to be connected to PostgreSQL schemata. The dump of another database with only the public schema completes fast and without problems.
The database that causes problems has four additional schemata - each owned by a different user and more privileges are given on database objects.

Thank you very much,

Peter
--
Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de