From: | Francisco Reyes <lists(at)stringsutils(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Superuser lost access to particular database |
Date: | 2006-09-13 05:01:19 |
Message-ID: | cone.1158123679.796720.74301.1000@zoraida.natserv.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom Lane writes:
> 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?
Backend.
pgsql 60769 47.8 1.3 17636 4888 ?? R 11:34AM 761:15.92 postmaster:
pgsql pablar [local] SELECT (postgres)
> 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?
Nothing happens when I try to run the query.
> 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.
What additional info can I provide?
Any additional troubleshooting I can try?
This one DB is preventing me from doing a pg_dumpall.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-09-13 05:10:57 | Re: Superuser lost access to particular database |
Previous Message | Michael Fuhr | 2006-09-13 03:29:17 | Re: INSERT does not finish except if it is carried out a few minutes after the creation of the table |