Nirav Parikh wrote: > Hi, > > I got this error message when I tried to do pg_dump on the database. > > pg_dump: ERROR: invalid memory alloc request size 4294967293 > pg_dump: SQL command to dump the contents of table "wordlist" failed: > PQendcopy() failed. > pg_dump: Error message from server: ERROR: invalid memory alloc request > size 4294967293 > pg_dump: The command was: COPY public.wordlist (word_id, word, > count_word) TO stdout; > > I went to phppgadmin and try to access the worldlist table and it also > gives me following error message: > > ERROR: could not access status of transaction 6849340 > DETAIL: could not open file "/var/lib/pgsql/data/pg_clog/0006": No such > file or directory What version is this? Also, is the system running with fsync=off or on disks with write cache enabled? -- Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 17.7", W 73º 14' 26.8" "La fuerza no está en los medios físicos sino que reside en una voluntad indomable" (Gandhi) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend