From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Francisco Reyes <lists(at)stringsutils(dot)com> |
Cc: | PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Superuser lost access to particular database |
Date: | 2006-09-12 16:47:17 |
Message-ID: | 16966.1158079637@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Francisco Reyes <lists(at)stringsutils(dot)com> writes:
> Tom Lane writes:
>> is the pg_dump or its backend consuming CPU, or just sitting?
> At 90% of my CPU.
The pg_dump process, or the backend?
> I have loggin set log_min_messages = info and log_statement = 'all'.
> Right after I start the pg_dump there is a flury of activity, which I am
> putting at http://public.natserv.net/pg_dump_log.txt, but very quickly it
> stops producing any output to the log.
The last query shown is
SELECT classid, objid, refclassid, refobjid, deptype FROM pg_depend WHERE deptype != 'p' ORDER BY 1,2
so apparently something is fishy about the dependency data. Can you
execute this query by hand and get results?
It could be that pg_depend is corrupted in a way that locks up the
backend trying to read it, or it could be that pg_dump is getting
confused and going into a loop trying to process the data. I can't
tell from this description.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | John McCawley | 2006-09-12 17:47:06 | Re: Bytea to Text problems |
Previous Message | Don Parris | 2006-09-12 16:47:03 | Question About Aggregate Functions |