Sebastián Baioni wrote:
I contacted the Admin and told me there was no erros nor in the postgresql log nor in the server log.
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 *Mensaje de error del servidor = Server's Error Message *El comando es: The command is *se abortó por un error: it was aborted because an error.
If it is something server-side then there should be something in your server logs.
However, if you're taking a backup, I would expect the input buffer to be growing on the client rather than the server.
I think the Server's error message is "abortó por un error", the error being out-of-memory on your client.
-- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq