"Alex Turner" <armtuk(at)gmail(dot)com> writes:
> I'm thinking I need a core file.
Yeah.
> I'm guessing I just restart
> postgresql from a user whos core file size limit is set to non zero?
Probably won't help if your start script does "su postgres" as most do.
What I'd try is putting the ulimit command in ~postgres/.profile or
whatever init files your shell happens to like.
regards, tom lane