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:
2) Restart postma
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:
> 2) Restart postmaster
>
>/etc/rc.d/init.d/postgresql
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:
...
ulimit -c unlimited
su -l postgres -s /bin/sh -c "/usr/local/pgsql/bin/pg_ctl -D $PGDATA
-p /usr/local/pgsql/bin/po
On Mon, Sep 26, 2005 at 07:03:06PM +0200, ruben wrote:
>
> I guess I'm doing something wrong:
>
> -bash-2.05b$ ulimit
> unlimited
Please read manpages, in this case bash: ulimit -a
Peter
---(end of broadcast)---
TIP 9: In versions below 8.0, the
ruben <[EMAIL PROTECTED]> writes:
>> As I recall, released versions of PostgreSQL usually dump core under
>> $PGDATA/base/. 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 Postgr
Thanks Tom and Michael:
Michael Fuhr wrote:
On Fri, Sep 23, 2005 at 05:11:19PM +0200, ruben wrote:
The operating system is Red Hat Linux release 8.0 (Psyche) and
PostgreSQL version is 7.4.6., without non-standard extensions.
I cannot find any core dump in the PGDATA directory /usr/local/pgs
On Fri, Sep 23, 2005 at 05:11:19PM +0200, ruben wrote:
> The operating system is Red Hat Linux release 8.0 (Psyche) and
> PostgreSQL version is 7.4.6., without non-standard extensions.
>
> I cannot find any core dump in the PGDATA directory /usr/local/pgsql (I
> don't know how to debug it to get
ruben <[EMAIL PROTECTED]> writes:
> I cannot find any core dump in the PGDATA directory /usr/local/pgsql (I
> don't know how to debug it to get a stack trace, I'll find out).
It would normally be in the per-database subdirectory
($PGDATA/base/NNN/) for the database where the problem occurs. Howe
Hi Michael:
The operating system is Red Hat Linux release 8.0 (Psyche) and
PostgreSQL version is 7.4.6., without non-standard extensions.
I cannot find any core dump in the PGDATA directory /usr/local/pgsql (I
don't know how to debug it to get a stack trace, I'll find out).
Thanks, Ruben.
On Fri, Sep 23, 2005 at 01:34:18PM +0200, ruben wrote:
>
> LOG: server process (PID 27688) was terminated by signal 11
This suggests a bug in the backend. There should be a core dump
somewhere under $PGDATA (unless resource limits prevent it or your
system is configured to put core dumps elsewhe
10 matches
Mail list logo
