pgadmin3 hangs during dump

Started by Dennis Gearonover 16 years ago3 messagesgeneral
Jump to latest
#1Dennis Gearon
gearond@sbcglobal.net

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 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.

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 trees have rights."

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

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

In reply to: Dennis Gearon (#1)
Re: pgadmin3 hangs during dump

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

#3Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Dennis Gearon (#1)
Re: pgadmin3 hangs during dump

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