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
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 |