Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





2012/9/14 Albe Laurenz <laurenz.albe@xxxxxxxxxx>

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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux