Re: ERROR: invalid memory alloc request size 4294967293

Run ulimit -a and verify the max memory size allowed for the postgres account.(I assume you are running postmaster under the postgres account, right?) The allowed size should be large enough for the postmaster plus shared buffers and several other GUCs that require memory.

Bob Lunney

--- On Tue, 1/4/11, Victor Hugo dos Santos <listas(dot)vhs(at)gmail(dot)com> wrote:

> From: Victor Hugo dos Santos <listas(dot)vhs(at)gmail(dot)com>
> Subject: [ADMIN] ERROR: invalid memory alloc request size 4294967293
> To: pgsql-admin(at)postgresql(dot)org
> Date: Tuesday, January 4, 2011, 8:48 AM
> Hello,
>
> Actually I use postgresql version  8.4.6-0ubuntu10.04
> in bacula server
> to save information about backups from bacula.
> But, 2 days ago, the postgresql make a error when I run the
> command
> pg_dump. This is the error:
>
> ====================
> 02-Jan 06:32 bacula-dir JobId 31005: BeforeJob: pg_dump:
> SQL command failed
> 02-Jan 06:32 bacula-dir JobId 31005: BeforeJob: pg_dump:
> Error message
> from server: ERROR:  invalid memory alloc request size
> 4294967293
> 02-Jan 06:32 bacula-dir JobId 31005:%2