Re: Can't make backup (again) - Mailing list pgsql-general

From Tom Lane
Subject Re: Can't make backup (again)
Date
Msg-id 9711.1200586601@sss.pgh.pa.us
Whole thread Raw
In response to Re: Can't make backup (again)  (Sebastián Baioni <sebaioni-postgresql@yahoo.com.ar>)
List pgsql-general
=?iso-8859-1?q?Sebasti=E1n=20Baioni?= <sebaioni-postgresql@yahoo.com.ar> writes:
> I forgot to tell that the error was seen on the client but it was a response from the server:
> pg_dump: Mensaje de error del servidor: cannot allocate memory for input buffer
> pg_dump: El comando es: COPY public.sipat00 (sipasede, ...) TO stdout;
> pg_dump: *** se abort� por un error

No, that error text only appears in libpq, so it's happening on the
client side --- pg_dump just doesn't know the difference between an
error sent from the server and one generated within libpq.

My guess is that there's some extremely wide row(s) in your database.
The client-side libpq has to be able to buffer the widest row during
a COPY, and your client machine doesn't seem to be up to the task...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Accessing composite type columns from C
Next
From: Bill Moran
Date:
Subject: Re: advocacy: drupal and PostgreSQL