Re: SQL command to dump the contents of table failed: PQendcopy()

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.