Re: Triggers in C - Segmentation Fault - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Triggers in C - Segmentation Fault
Date
Msg-id 20060515124408.GC18700@svana.org
Whole thread Raw
In response to Re: Triggers in C - Segmentation Fault  ("Chris Coleman" <chris@karumbo.com>)
List pgsql-general
The core file usually appears in the data directory of the backend.

If you still can't find it, you can try attaching gdb to the running
backend. After the connection has started, find the backend (not the
postmaster) and attach using:

gdb -p <pid>

Once connected, type "cont" and proceed with the actions to trigger the
segfault. When the segfault happens, gdb will catch it and you can type
"bt" to see where you are...

Have a ncie day,

On Mon, May 15, 2006 at 11:47:24AM +0100, Chris Coleman wrote:
> Hi,
>
> I have done the below command and restarted the server and built my
> triggers with the -g command using gcc, but I cannot seem to find any
> core files nor any reference to where postgres may place them. Where
> would they normally appear?
>
> Cheers
> Chris
>
> >Probably the easiest thing to do is make sure your functions are
> >compiled with debugging and enable core dump by running "ulimit -S -c
> >unlimited" before starting the server. You can then use gdb to
> >pin-point where it dies...
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: Perez
Date:
Subject: Re: trigger TOASTing quicker?
Next
From: "A. Kretschmer"
Date:
Subject: Re: Pass in variable from user???