Thanks Martijn:
Martijn van Oosterhout wrote:
On Wed, Sep 28, 2005 at 11:40:11AM +0200, ruben wrote:
Hi Tom:
No way to get the core dump, this is what I did:
1) Add "ulimit" to /etc/rc.d/init.d/postgresql just before pg_ctl start
in the "start" section of the script:
<snip>
2) Restart postmaster
/etc/rc.d/init.d/postgresql restart
Does that run the start section? Maybe you need to stop/start. Maybe
the bash_profile/bashrc for the postgres user resets the core limit.
The server has been rebooted.
This is the postgres start script ($PGDATA is /usr/local/pgsql/):
http://80.33.3.245/temp/postgres.txt
Regading the core limit:
-bash-2.05b$ whoami
postgres
-bash-2.05b$ cat ~/.bash_profile
PGDATA=/var/lib/pgsql/data
[ -f $PGDATA/../initdb.i18n ] && source $PGDATA/../initdb.i18n
export PGDATA
-bash-2.05b$ ulimit -a
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 7168
virtual memory (kbytes, -v) unlimited
4) Search core file:
-bash-2.05b$ find /usr/local/pgsql/ -name '*core*' -print
-bash-2.05b$
It'll be under $PGDATA, where is that? It may be under
/var/lib/postgres, depending on how you installed...
Indeed I searched the whole file structure for core files.
Regards.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
