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

2005-09-28 Thread ruben
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

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

2005-09-28 Thread Martijn van Oosterhout
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

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

2005-09-28 Thread ruben
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

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

2005-09-26 Thread ruben
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

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

2005-09-26 Thread Tom Lane
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

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

2005-09-26 Thread Peter Wiersig
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

[GENERAL] SQL command to dump the contents of table failed: PQendcopy() failed. Error message from server: socket not open

2005-09-23 Thread ruben
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

Re: [GENERAL] SQL command to dump the contents of table failed: PQendcopy() failed. Error message from server: socket not open

2005-09-23 Thread Michael Fuhr
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

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

2005-09-23 Thread ruben
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.

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

2005-09-23 Thread Tom Lane
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.

Re: [GENERAL] SQL command to dump the contents of table failed: PQendcopy() failed. Error message from server: socket not open

2005-09-23 Thread Michael Fuhr
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