Vlad Seryakov <vlad(at)crystalballinc(dot)com> writes:
> Is it possible to get core file, i couldn't find how to setup this.
A crashed backend should leave a core file in $PGDATA/base/YOURDB/core
If you don't see a core file in that directory, it's possible that
the postmaster was started with "ulimit -c 0" to forbid core dumping.
(I think most Linuxen run their boot scripts with this setting.)
Restart the postmaster with "ulimit -c unlimited" to allow core dumping.
You might want to add that command to the boot script for Postgres.
regards, tom lane