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

From: Yvon Thoraval <yvon(dot)thoraval(at)gmail(dot)com>
To: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SQLSTATE[08006] [7] server closed the connection unexpectedly
Date: 2012-09-14 16:50:05
Message-ID: CAG6bkBy=tBSGuxy0ejYx1ZaOHSRY3wEuaps-EOrN1foiJVvKBA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2012/9/14 Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)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(at)D620 /home/yt/Sites/yt_tests $

--
Yvon

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message jam3 2012-09-14 17:06:19 Re: Would my postgresql 8.4.12 profit from doubling RAM?
Previous Message Yvon Thoraval 2012-09-14 16:39:13 Re: SQLSTATE[08006] [7] server closed the connection unexpectedly