Re: Help with Segmentation Fault

"Patrick Bye (WFF)" <PBYE(at)Westfair(dot)CA> writes:
> I just tried to upgrade to the lastest 7.3.2. I did a dumpall on my
> database and wiped out both my binary and data directories so I could start
> the install from scratch. The configure, make and make install work fine.
> No errors reported from initdb and postmaster starts no problem. As soon as
> I try to connect to template1 to restore my dumpall, I get a segmentation
> fault. If I try to do a createdb, I also get a segmentation fault.

You have not provided a whole lot of detail here, but reading between
the lines I guess that it is psql core-dumping, not the backend?
Most likely that would be a problem of incompatibility with one of the
shared libraries that psql depends on. It's difficult to say more than
that with no details though. Did you build 7.3.2 yourself (if so, with
what configure switches) or install an RPM (if so, whose)? Can you
provide a stack trace from the segfault core dump? Does ldd on the psql
executable report a sane-looking set of shlib dependencies?

regards, tom lane