2012/9/14 Albe Laurenz <laurenz.albe@xxxxxxxxxx>
You may want to set log_statement='all' in postgresql.confYvon Thoraval wrote:
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
