pg_dump error
pg_dump error
От:
Ferdinand Smit <ferdinand@telegraafnet.nl>
Дата:
Hi, What does this mean ?!? Is this a corrupt database, a bug or has the pg_dump not enough memory ? And ... how can i solve this problem ? $ pg_dump login | gzip > login.dump.gz pg_dump: ERROR: MemoryContextAlloc: invalid request size 4294967293 pg_dump: lost synchronization with server, resetting connection pg_dump: SQL command to dump the contents of table "postcodereeks" failed: PQendcopy() failed. pg_dump: Error message from server: pg_dump: The command was: COPY "postcodereeks" TO stdout; $ psql -c 'COPY "postcodereeks" TO stdout;' login > /tmp/postcodereeks ERROR: MemoryContextAlloc: invalid request size 4294967293 lost synchronization with server, resetting connection Config: Machine; dual PIII with 1 Gb memory DB version: PG 7.2.1 postgres.conf: shared_buffers = 2048 sort_mem = 1024 Regards, Ferdinand
Re: pg_dump error
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Ferdinand Smit writes: > What does this mean ?!? Is this a corrupt database, a bug or has the pg_dump > not enough memory ? > $ pg_dump login | gzip > login.dump.gz > pg_dump: ERROR: MemoryContextAlloc: invalid request size 4294967293 > pg_dump: lost synchronization with server, resetting connection > pg_dump: SQL command to dump the contents of table "postcodereeks" failed: > PQendcopy() failed. First guess is a corrupted data value in table postcodereeks. Possibly you can narrow down which row(s) have bad data and remove 'em. regards, tom lane