Re: SQLSTATE[08006] [7] server closed the connection unexpectedly

2012/9/14 Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)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