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

Поиск
Список
Период
Сортировка
От Yvon Thoraval
Тема Re: SQLSTATE[08006] [7] server closed the connection unexpectedly
Дата
Msg-id CAG6bkBy=tBSGuxy0ejYx1ZaOHSRY3wEuaps-EOrN1foiJVvKBA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SQLSTATE[08006] [7] server closed the connection unexpectedly  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Ответы Re: SQLSTATE[08006] [7] server closed the connection unexpectedly
Список pgsql-general
Дерево обсуждения


2012/9/14 Albe Laurenz <laurenz.albe@wien.gv.at>
Yvon Thoraval wrote:
You may want to set log_statement='all' in postgresql.conf

i did this change , restart PostgreSQL and test again, with the same error, however postgres log didn't report any error, as far as i understand the log :
 
2012-09-14 18:43:14 CEST LOG:  received fast shutdown request
2012-09-14 18:43:14 CEST LOG:  aborting any active transactions
2012-09-14 18:43:14 CEST LOG:  autovacuum launcher shutting down
2012-09-14 18:43:14 CEST LOG:  shutting down
2012-09-14 18:43:14 CEST LOG:  database system is shut down
2012-09-14 18:43:17 CEST LOG:  database system was shut down at 2012-09-14 18:43:14 CEST
2012-09-14 18:43:17 CEST LOG:  incomplete startup packet
2012-09-14 18:43:17 CEST LOG:  database system is ready to accept connections
2012-09-14 18:43:17 CEST LOG:  autovacuum launcher started
2012-09-14 18:43:18 CEST LOG:  statement: SELECT d.datname as "Name",
      pg_catalog.pg_get_userbyid(d.datdba) as "Owner",
      pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding",
      d.datcollate as "Collate",
      d.datctype as "Ctype",
      pg_catalog.array_to_string(d.datacl, E'\n') AS "Access privileges"
FROM pg_catalog.pg_database d
ORDER BY 1;
2012-09-14 18:43:19 CEST LOG:  statement: SELECT d.datname as "Name",
      pg_catalog.pg_get_userbyid(d.datdba) as "Owner",
      pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding",
      d.datcollate as "Collate",
      d.datctype as "Ctype",
      pg_catalog.array_to_string(d.datacl, E'\n') AS "Access privileges"
FROM pg_catalog.pg_database d
ORDER BY 1;
2012-09-14 18:43:19 CEST LOG:  statement: SELECT d.datname as "Name",
      pg_catalog.pg_get_userbyid(d.datdba) as "Owner",
      pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding",
      d.datcollate as "Collate",
      d.datctype as "Ctype",
      pg_catalog.array_to_string(d.datacl, E'\n') AS "Access privileges"
FROM pg_catalog.pg_database d
ORDER BY 1;
yt@D620 /home/yt/Sites/yt_tests $ 



--
Yvon


В списке pgsql-general по дате отправления: