Re: pgadmin3 hangs during dump

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Dennis Gearon *EXTERN*" <gearond(at)sbcglobal(dot)net>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: pgadmin3 hangs during dump
Date: 2009-10-19 07:58:00
Message-ID: D960CB61B694CF459DCFB4B0128514C203937FB8@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sergey Konoplev 2009-10-19 12:20:49 Best practices for effective_io_concurrency
Previous Message Gerhard Wiesinger 2009-10-19 05:39:00 Re: Function returning 2 columns evaluated twice when both columns are needed