Re: SQL command to dump the contents of table failed: PQendcopy() - Mailing list pgsql-general

From Tom Lane
Subject Re: SQL command to dump the contents of table failed: PQendcopy()
Date
Msg-id 2003.1127762841@sss.pgh.pa.us
Whole thread Raw
In response to Re: SQL command to dump the contents of table failed: PQendcopy()  (ruben <ruben20@superguai.com>)
Responses Re: SQL command to dump the contents of table failed: PQendcopy()
List pgsql-general
ruben <ruben20@superguai.com> writes:
>> As I recall, released versions of PostgreSQL usually dump core under
>> $PGDATA/base/<database oid>.  However, it's also possible that your
>> coredumpsize resource limit prevents core dumps; you could fix that
>> by putting a command like "ulimit -c unlimited" in your PostgreSQL
>> startup script and then stopping and restarting PostgreSQL.

> I cannot find a core file, ulimit is set to unlimit. I guess I'm doing
> something wrong:

> -bash-2.05b$ ulimit
> unlimited
> -bash-2.05b$ find /usr/local/pgsql -name '*core*' -print

(1) The fact that it's unlimited in your user environment doesn't prove
that it's unlimited in the environment the postmaster is started in.

(2) I forget which constraint ulimit-with-no-argument prints, but it's
not core file size.  (Try "ulimit -a")

Please actually follow the advice given to you above.

            regards, tom lane

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Slow search.. quite clueless
Next
From: Tom Lane
Date:
Subject: Re: Error migrating from 7.4.3 to 8.0.3