Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm getting the following error in my postgres 8.4 database:

XX000: invalid memory alloc request size 4294967290

Operating System : Windows 7 64 bit Memory : 8GB Database Version: Postgres 8.4 server

I cannot back up my database; I can't even view the data using SELECT. The server gets automatically stopped when I try to do this.

Also posted:

i added the screen shot of the error which occurred during executing the following

select * from < tablename >

enter image description here

ERROR: invalid memory alloc request size 4294967290

          • ERROR * * * * * *

ERROR: invalid memory alloc request size 4294967290

SQL state: XX000

share|improve this question

migrated from stackoverflow.com Mar 1 '13 at 21:22

This question came from our site for professional and enthusiast programmers.

"EDB-XX000" suggests that you're actually using EnterpriseDB Postgres Plus or EnterpriseDB Postgres Advanced Server, not PostgreSQL its self. You should really update this with a lot more detail, like the OS you're running on, the message(s) in the logs before the error,etc. –  Craig Ringer Mar 1 '13 at 5:05
You should (a) treat this as possible database corruption as per wiki.postgresql.org/wiki/Corruption even though it probably isn't, and after that (b) try updating to the latest 8.4.x point release of whatever you're actually using. If that doesn't help, try asking on the EnterpriseDB forums. If you do so, post a link to your EDB forum post here. –  Craig Ringer Mar 1 '13 at 5:09
You could've mentioned that you already posted here: forums.devshed.com/postgresql-help-21/… . And that you read and commented on this too: forums.enterprisedb.com/posts/list/953.page –  Craig Ringer Mar 1 '13 at 5:18
Downvoted: Low effort question, missing key information, no info about earlier posts. Will remove downvote if the question is fixed to provide adequate detail and refer to other posts. –  Craig Ringer Mar 1 '13 at 5:20
@CraigRinger: Why place the assessment of "low effort" on the poster? Why not just leave it at describing the problem of "missing key information" without judging the person who wrote it? –  Andy Lester Mar 1 '13 at 6:02

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.