Thanks - I tracked down the offending row and deleted it. Just in case anyone wishes to know how
select * from site where id < 5000 (no error) select * from site where id < 10000 (no error) select * from site where id < 15000 (error) ... select * from site where id = 12344 (no error) select * from site where id = 12345 (error) delete from site where id = 12345 (error) On 2/6/07, Shoaib Mir <[EMAIL PROTECTED]> wrote:
Hmmm that looks like to me a HW problem causing data corruption. Try doing a REINDEX for the database, if possible restart the database server machine and then try taking the dump again to see if that works. But I will recommend doing memory tests for the hardware... -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 1/31/07, airbulb < [EMAIL PROTECTED]> wrote: > > Hello > > I get the following error when dumping a pg database with WIN_1252 > encoding: > > pg_dump --clean --no-owner dumpfile | gzip > >/home/postgres/globalen.dump.gz 2>>./err.out > > pg_dump: ERROR: invalid memory alloc request size 4294967293 > pg_dump: SQL command to dump the contents of table "site" failed: > PQendcopy() failed. > pg_dump: Error message from server: ERROR: invalid memory alloc request > size 4294967293 > pg_dump: The command was: COPY public.site (site_id, url, status, > created, "domain", title) TO stdout; > > Possibly related is a particular query with pgAdmin on same site table > with above error yields > ERROR: invalid multibyte character for locale > > I have upgraded from 8.1.2 to 8.1.6 but get the same error. > > Any help appreciated. > > Regards, > David. >
-- ----------------------------- David Cotter CTO Alatto Technologies Ltd ----------------------------- [EMAIL PROTECTED] m. +353 87 6293698 t. +353 1 2090700 (main) t. +353 1 2090779 (direct) f. +353 1 2090707 www.alatto.com ----------------------------- The new way to mobile browse: http://tribes.cc/demo
