Skip site navigation (1) Skip section navigation (2)

Re: ERROR: invalid memory alloc request size

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Johann Spies <jspies(at)sun(dot)ac(dot)za>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: ERROR: invalid memory alloc request size
Date: 2007-05-16 17:50:04
Message-ID: 5221.1179337804@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Johann Spies <jspies(at)sun(dot)ac(dot)za> writes:
> * Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [070514 16:36]:
>> $ gdb /path/to/postgres PID-of-backend

> Which pg-process?  The Postmaster or psql?  I have done this for the
> Postmaster now but
>> gdb> b errfinish
>> gdb> cont
>> ... wait for breakpoint to be hit ...
> This did not happen although the error occurred (after a few hours).

You got the wrong process then --- maybe the postmaster itself rather
than the backend assigned to your psql session?  You can identify the
backend PID via pg_backend_pid() within the psql session of interest,
or look in pg_stat_activity.

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2007-05-16 19:12:12
Subject: Re: query becomes much slower after Postgres 8.2.4 and Postgis 1.2.1 upgrade
Previous:From: Keaton AdamsDate: 2007-05-16 17:08:04
Subject: Re: WAL file utilization question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group