From: | "Morgan Kita" <mkita(at)verseon(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | pg_dump failes due to invalid memory request |
Date: | 2005-09-02 04:06:12 |
Message-ID: | 08B420FF5BF7BC42A064212C2EB768801C10C0@neutron.verseon.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
I just tried to call pg_dump for my database this evening, and it fails on one of my tables.
The error it gives in the log is:
ERROR: invalid memory alloc request size 3221230573
So at this point what do I do?
What I have done:
I reindexed the table sucessfully, and it made no difference.
I tried grabbing all the rows around the last row that was sucessfully dumped through a select statment. That worked sucessfully.
How do I test/fix this?
I am assuming something is corrupted but I am not sure how to figure out what. I have had nothing in the logs to indicate a corruption. Now the only thing I can think of is that this particular table has 2 custom data types that are both toastable. I am guessing that number indicates a bad header value at the beginning of one of the custom data types.
Please help!
Thanks,
Morgan
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-09-02 04:18:07 | Re: pg_dump failes due to invalid memory request |
Previous Message | me | 2005-09-02 02:48:33 | Re: triggers: how to check if a field changed? |