Re: [GENERAL] psql segmentation fault

"Bogus User" wrote:
  >Hi,
  >
  >I'm running Debian Linux 2.1 and I downloaded and installed
  >Postgresql v6.5beta1.  I went through the steps in the INSTALL
  >file and everything seemed ok.  I can start the postmaster, but
  >when I try to run psql I get a segmentation fault.
  >
  >The exact output from psql is:
  >
  >$ psql
  >Welcome to the POSTGRESQL interactive sql monitor:
  >Please read the file COPYRIGHT for copyright terms of POSTGRESQL
  >[PostgreSQL 6.5.0 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.6]
  >
  >  type \? for help on slash commands
  >  type \q to quit
  >  type \g or terminate with semicolon to execute query
  >You are currently connected to the database: postgres
  >
  >Segmentation fault
  >$

Use gdb to find out where it is failing:

$ gdb psql
When it segfaults, use `bt' to print the backtrace.


One difference between the Debian package and standard psql is that
the Debian package will automatically connect you to template1 if you
don't specify a database; this may have a bearing on your problem.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "Bless them which persecute you: bless, and curse not."
                   Romans 12:14