Обсуждение: pgadmin3 hangs during dump

Поиск
Список
Период
Сортировка

pgadmin3 hangs during dump

От
Dennis Gearon
Дата:
Is this the right place to post this?

I set up the same characteristics on the console, and it runs fine, (COPY commands will import back, right? That's what
itoutput.) 

On the console, it was:
pg_dump -vaF p -f dbase.sql -U user-name dbase-name

More details:
     about 11 tables, practically empty.
     no other fancy stuff like functions/views/installed languages/blah,blah
     running on Ubuntu latptop

I don't know if I have log files set up or where they'd be.


Dennis Gearon

Signature Warning
----------------
EARTH has a Right To Life

I agree with Bolivian President Evo Morales

# The right to life: "The right for no ecosystem to be eliminated by the irresponsible acts of human beings."

# The right of biosystems to regenerate themselves: "Development cannot be infinite. There's a limit on everything."

# The right to a clean life: "The right for Mother Earth to live without contamination, pollution. Fish and animals and
treeshave rights." 

# The right to harmony and balance between everyone and everything: "We are all interdependent."


See the movie - 'Inconvenient Truth'
See the movie - 'Syriana'

Re: pgadmin3 hangs during dump

От
Peter Geoghegan
Дата:
> Is this the right place to post this?

No, pgsql-general@postgresql.org is no place for posting questions
about PgAdmin3, or for fatuous left wing rants.

Regards,
Peter Geoghegan

Re: pgadmin3 hangs during dump

От
"Albe Laurenz"
Дата:
Dennis Gearon wrote:
> I set up the same characteristics on the console, and it runs
> fine, (COPY commands will import back, right? That's what it output.)
>
> On the console, it was:
> pg_dump -vaF p -f dbase.sql -U user-name dbase-name
>
> More details:
>      about 11 tables, practically empty.
>      no other fancy stuff like functions/views/installed languages/blah,blah
>      running on Ubuntu latptop
>
> I don't know if I have log files set up or where they'd be.

Well, what is needed so that anyone can help are still more details,
like the software versions involved, whether the problem is repeatable
or not, whether pgAdmin III hangs in the database or not (pg_locks ?),
if yes, in which query it hangs, what exactly is getting dumped when
it hangs, and best of all a self-contained example that would enable
somebody else to reproduce the problem.

Yours,
Larenz Albe