Thread: psql crashes postmaster

Krzysztof Czuma (czuma@Elektron.pl) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
psql crashes postmaster

Long Description
PostgreSQL 7.0.3, SunOS amber 5.8 Generic_108529-05 i86pc i386 i86pc
gcc version 2.95.2

postmaster crashes every time a user tries to access database from psql

Sample Code
psql
Password:
psql: pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
psql
psql: connectDBStart() -- connect() failed: No such file or directory
        Is the postmaster running at 'localhost'
        and accepting connections on Unix socket '5432'?

No file was uploaded with this report

pgsql-bugs@postgresql.org writes:
> postmaster crashes every time a user tries to access database from psql

Does it fail for all users, or just some?  Did it used to work and is
now failing, or is this a new installation that's never worked?

What shows up in the postmaster log when this happens?  (If you're not
running with a postmaster log, reconsider that.)  Is there a core file
left behind, and if so what does gdb show for the backtrace?

            regards, tom lane

Hello,

On Sun, 25 Feb 2001, Tom Lane wrote:

> pgsql-bugs@postgresql.org writes:
> > postmaster crashes every time a user tries to access database from psql
>
> Does it fail for all users, or just some?

For one user. I deleted user and this database and created them again. Now
it works.


> Did it used to work and is
> now failing, or is this a new installation that's never worked?

I am not sure when the user started to use his database. He claimed, he
has been using the database one month.


> What shows up in the postmaster log when this happens?  (If you're not
> running with a postmaster log, reconsider that.)

I tried to find how to read pg_log but I failed. :)


Kind regards,
Krzysztof Czuma