psql Segmentation fault

From: Robert Landrum <rlandrum(at)aol(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: psql Segmentation fault
Date: 2007-11-14 19:57:03
Message-ID: 473B530F.8060108@aol.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Since we converted to PG8, we've been experiencing segfaults when the
psql client exits. It doesn't have any real effect on things... or it
hasn't until now.

RHEL4 i686 - PostgresQL 8.2.4 (non-redhat)

-bash-3.00$ psql -n
Welcome to psql 8.2.4, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

postgres=# \q
Segmentation fault

That's what happens every time. No core file is produced. I've done
some searches and discovered that this might be related to readline.
But that doesn't seem right since it crashes when I run psql -n (no
readline support). I've tried removing .psql_history files and even
changing perms to prevent writes. Nothing seems to work.

Now it's affecting pg_dumpall -g, which we use to backup all user
accounts and roles. It seems to seqfault before it finishes writing
STDOUT, which means some users/roles aren't being dumped.

Anyone else run into this problem? What is the solution?

Thanks,

Rob

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-11-14 20:04:43 Re: psql Segmentation fault
Previous Message Dave Page 2007-11-14 19:52:18 Re: PLpgsql debugger question