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
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
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
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
ruben [EMAIL PROTECTED] 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
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
Hi:
I run a cron job every day to dump all the tables in my 7.4 Postgres
database. For one of the tables (sample) the command returns this error:
-bash-2.05b$ /usr/local/pgsql/bin/pg_dump -Fc -t sample heos -f
/home/bu/5/sample.dump
pg_dump: socket not open
pg_dump: SQL command to dump the
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
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.
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.
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 a
11 matches
Mail list logo