The following bug has been logged online: Bug reference: 3738 Logged by: Chris Vickery Email address: cvickery@gmail.com PostgreSQL version: 8.2.5 Operating system: OS X 10.4 Description: psql crashes on exit. Details: senate=# \q psql(4484) malloc: *** error for object 0x1806200: incorrect checksum for freed object - object was probably modified after being freed, break at szone_error to debug psql(4484) malloc: *** set a breakpoint in szone_error to debug Segmentation fault The problem didn't always occur, and I cannot say what caused it to start happening. But it happens every time now. I have sometimes been running the current version of pgAdmin3 concurrently with psql, if that's a clue. The problem started when running 8.2.4, so I backed up the database (using dumpall from 8.2.4), upgraded to 8.2.5, and restored the database: same problem. The above output is from the first run of psql after the upgrade; I have not run pgAdmin3 since the upgrade. "szone_error" is an OS X library routine, but I'm not enough of an OS X developer to know how to get at it. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend

"Chris Vickery" <cvickery@gmail.com> writes: > Description: psql crashes on exit. We've seen this before --- there's a bug in the Apple-supplied libedit: http://archives.postgresql.org/pgsql-hackers/2006-12/msg01222.php My suggestion would be to rebuild using libreadline, which is a lot more featureful anyway. If you don't want to do that, removing ~/.psql_history will make it go away (for awhile). regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match