Re: SQLSTATE[08006] [7] server closed the connection unexpectedly - Mailing list pgsql-general

From Yvon Thoraval
Subject Re: SQLSTATE[08006] [7] server closed the connection unexpectedly
Date
Msg-id CAG6bkBxW7PDjZ1n_oha7pwFW_RSeo7+xC0cu7CDnrUjtr0ZXyg@mail.gmail.com
Whole thread Raw
In response to Re: SQLSTATE[08006] [7] server closed the connection unexpectedly  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general


2012/9/14 Albe Laurenz <laurenz.albe@wien.gv.at>

Is this repeatable?

YES, may be i didn't mention that about the same config on another computer running mac OS X, works very well with same php script. Also this php script was working 2 months ago...
i suspect something had changed on Xubuntu within pdo, php and psql ?
 
That message normally means that the server process crashed.

I don't think so because even after this error I'm still able to connect to the db that way :
 $ psql -h localhost -U yt -d yt_tests
Password for user yt: 
psql (9.1.5)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type "help" for help.

yt_tests=> select * from weather;
     city      | temp_lo | temp_hi | prcp |    date    
---------------+---------+---------+------+------------
 San Francisco |      46 |      50 | 0.25 | 1994-11-27
 Hayward       |      37 |      54 |      | 1994-11-29
 San Francisco |      43 |      57 |    0 | 1994-11-29
(3 rows)

yt_tests=> \q

What is in the PostgreSQL server log file?

Nothing mentionned about this prob.
 
You may want to set log_statement='all' in postgresql.conf

OK, fine thanks, I'll do that ASAP and repost.
 
to get more context.

Yours,
Laurenz Albe



--
Yvon


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: OFFTOPIC: core dumped with strcpy,atoi,sprintf.
Next
From: Yvon Thoraval
Date:
Subject: Re: SQLSTATE[08006] [7] server closed the connection unexpectedly