Re: Can't make backup (again)

Sebastián Baioni wrote:
> Hi,
> Some days ago we were having problems running pg_dump (v. 8.2.5.7260) from Windows XP SP2 to a database in a sever PostgreSQL 8.2.5 on amd64-portbld-freebsd6.2.
> We thought the problem was solved but we are having problems again.
> Now we got an error:
> "cannot allocate memory for input buffer"
> The command was: "COPY public.sipat00 (sipasede, ... ) TO stdout;
>
> ¿Is this a memory problem?

Well, yes you can't allocate memory.

> ¿From server (FreeBSD) or from client PC (Windows XP)?

Did you see the error on the client PC or the server?
What do the server logs show?
What was the memory usage on the client when this happened?

--
Richard Huxton
Archonet Ltd