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