Concordo com vcs, dei uma carga maior e usei o último log gerado....
agora tem mais q "4 linhas" mas o erro continua....segue os testes e comando
pgfouine e o mesmo..erro...
começo a achar que é o problema é o time zone
Obrigado Flavio e Dickson....
testes:
grep log_line_prefix postgresql.conf
log_line_prefix = '%t [%p]: [%l-1] ' # special values
grep dura postgresql-2011-09-30_000000.log > saida1.log
[root@homologacaosipac pg_log]# vim saida1.log
2011-09-30 08:27:03 BRT [19966]: [1-1] LOG: duration: 3.977 ms statement:
SELECT version();
2011-09-30 08:27:03 BRT [19966]: [2-1] LOG: duration: 6.300 ms statement:
SET DateStyle=ISO;
2011-09-30 08:27:08 BRT [19968]: [1-1] LOG: duration: 3.101 ms statement:
SET DateStyle=ISO;
2011-09-30 08:27:12 BRT [19969]: [1-1] LOG: duration: 8.213 ms statement:
SELECT version();
2011-09-30 08:27:12 BRT [19969]: [2-1] LOG: duration: 9.378 ms statement:
SET DateStyle=ISO;
2011-09-30 08:27:26 BRT [19971]: [1-1] LOG: duration: 3.978 ms statement:
SET DateStyle=ISO;
2011-09-30 08:27:31 BRT [19971]: [2-1] LOG: duration: 3.071 ms statement:
SELECT groname FROM pg_group ORDER BY groname
2011-09-30 08:27:31 BRT [19971]: [3-1] LOG: duration: 2.707 ms statement:
SELECT name, vartype, min_val, max_val
2011-09-30 08:28:19 BRT [19971]: [8-1] LOG: duration: 4.239 ms statement:
SELECT db.oid, datname, db.dattablespace AS spcoid, spcname, datallowconn,
(SELECT array(select coalesce('''' || rolname || '''', '') || '=' ||
unnest(setconfig) FROM pg_db_role_setting setting LEFT JOIN pg_roles role ON
setting.setrole=role.oid WHERE setdatabase = db.oid)) AS datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba) AS
datowner,has_database_privilege(db.oid, 'CREATE') as cancreate,
2011-09-30 08:28:20 BRT [19978]: [1-1] LOG: duration: 2.015 ms statement:
SELECT version();
2011-09-30 08:28:20 BRT [19978]: [2-1] LOG: duration: 3.280 ms statement:
SET DateStyle=ISO;
2011-09-30 08:28:20 BRT [19978]: [3-1] LOG: duration: 5.745 ms statement:
SELECT 2 AS nsptyp,
2011-09-30 08:28:20 BRT [19978]: [4-1] LOG: duration: 3.079 ms statement:
SELECT CASE WHEN nspname LIKE E'pg\\_temp\\_%' THEN 1
2011-09-30 08:28:21 BRT [19978]: [5-1] LOG: duration: 102.655 ms
statement: SELECT COUNT(*) FROM
2011-09-30 08:28:29 BRT [19971]: [9-1] LOG: duration: 947.902 ms
statement: DROP DATABASE administrativo_producao;
2011-09-30 08:28:29 BRT [19971]: [10-1] LOG: duration: 2.097 ms statement:
SELECT proname FROM pg_proc WHERE proname='pg_get_viewdef' AND
proargtypes[1]=16
2011-09-30 08:28:29 BRT [19971]: [11-1] LOG: duration: 28.156 ms
statement: SELECT 2 AS nsptyp,
2011-09-30 08:28:29 BRT [19971]: [12-1] LOG: duration: 2.166 ms statement:
SELECT COUNT(*) FROM
2011-09-30 08:28:51 BRT [19971]: [13-1] LOG: duration: 5815.878 ms
statement: CREATE DATABASE administrativo_producao
2011-09-30 08:28:54 BRT [19981]: [1-1] LOG: duration: 2.481 ms statement:
SELECT version();
2011-09-30 08:28:54 BRT [19981]: [2-1] LOG: duration: 4.392 ms statement:
SET DateStyle=ISO;
2011-09-30 08:28:54 BRT [19981]: [3-1] LOG: duration: 4.494 ms statement:
SELECT 2 AS nsptyp,
2011-09-30 08:28:54 BRT [19981]: [4-1] LOG: duration: 3.082 ms statement:
SELECT COUNT(*) FROM
2011-09-30 08:31:36 BRT [20012]: [1-1] LOG: duration: 18.298 ms statement:
CREATE SCHEMA academico;
2011-09-30 08:31:36 BRT [20012]: [2-1] LOG: duration: 5.339 ms statement:
ALTER SCHEMA academico OWNER TO sipac;
2011-09-30 08:31:36 BRT [20012]: [3-1] LOG: duration: 11.840 ms statement:
COMMENT ON SCHEMA academico IS 'Esquema utilizado para importação das
informações do Sistema Acadêmico';
2011-09-30 08:31:36 BRT [20012]: [4-1] LOG: duration: 5.759 ms statement:
CREATE SCHEMA almoxarifado;
2011-09-30 08:31:36 BRT [20012]: [5-1] LOG: duration: 5.879 ms statement:
ALTER SCHEMA almoxarifado OWNER TO sipac;
2011-09-30 08:31:36 BRT [20012]: [6-1] LOG: duration: 5.874 ms statement:
COMMENT ON SCHEMA almoxarifado IS 'Esquema do sistema de almoxarifado';
2011-09-30 08:31:36 BRT [20012]: [7-1] LOG: duration: 5.933 ms statement:
CREATE SCHEMA arquivo_siape;
2011-09-30 08:31:36 BRT [20012]: [8-1] LOG: duration: 7.063 ms statement:
ALTER SCHEMA arquivo_siape OWNER TO sipac;
2011-09-30 08:31:36 BRT [20012]: [9-1] LOG: duration: 4.439 ms statement:
CREATE SCHEMA atendimento;
2011-09-30 08:31:36 BRT [20012]: [10-1] LOG: duration: 5.921 ms statement:
ALTER SCHEMA atendimento OWNER TO sipac;
2011-09-30 08:31:36 BRT [20012]: [11-1] LOG: duration: 5.865 ms statement:
COMMENT ON SCHEMA atendimento IS 'Esquema utilizado pelo sistema de controle
de atendimento do departamento de administração de pessoal. Controle das
filas de atendimento e atendimentos realizados.';
2011-09-30 08:31:36 BRT [20012]: [12-1] LOG: duration: 5.453 ms statement:
CREATE SCHEMA auditoria;
2011-09-30 08:31:36 BRT [20012]: [13-1] LOG: duration: 5.851 ms statement:
ALTER SCHEMA auditoria OWNER TO sipac;
2011-09-30 08:31:36 BRT [20012]: [14-1] LOG: duration: 11.879 ms
statement: COMMENT ON SCHEMA auditoria IS 'Esquema do subsistema de
auditoria';
2011-09-30 08:31:36 BRT [20012]: [15-1] LOG: duration: 5.756 ms statement:
CREATE SCHEMA avaliacao;
2011-09-30 08:31:36 BRT [20012]: [16-1] LOG: duration: 29.591 ms
statement: ALTER SCHEMA avaliacao OWNER TO sipac;
2011-09-30 08:31:36 BRT [20012]: [17-1] LOG: duration: 13.583 ms
statement: COMMENT ON SCHEMA avaliacao IS 'Esquema referente à Gestão de
Desempenho Humano - planos, avaliação de servidores, gio probatório';
2011-09-30 08:31:36 BRT [20012]: [18-1] LOG: duration: 16.326 ms
statement: CREATE SCHEMA boletim;
2011-09-30 08:31:36 BRT [20012]: [19-1] LOG: duration: 5.940 ms statement:
ALTER SCHEMA boletim OWNER TO sipac;
2011-09-30 08:31:36 BRT [20012]: [20-1] LOG: duration: 5.751 ms statement:
COMMENT ON SCHEMA boletim IS 'Armazena tabelas relacionadas ao subsistema
boletim de servicos';
2011-09-30 08:31:37 BRT [20012]: [21-1] LOG: duration: 5.899 ms statement:
CREATE SCHEMA bolsas;
2011-09-30 08:31:37 BRT [20012]: [22-1] LOG: duration: 5.771 ms statement:
ALTER SCHEMA bolsas OWNER TO sipac;
2011-09-30 08:31:37 BRT [20012]: [23-1] LOG: duration: 5.868 ms statement:
COMMENT ON SCHEMA bolsas IS 'Esquema com as tabelas do Sub-Sistema de
Bolsas';
2011-09-30 08:31:37 BRT [20012]: [24-1] LOG: duration: 5.847 ms statement:
CREATE SCHEMA capacitacao;
2011-09-30 08:31:37 BRT [20012]: [25-1] LOG: duration: 6.003 ms statement:
ALTER SCHEMA capacitacao OWNER TO sipac;
"saida1.log" 36089L,
5282164C
grep BRT postgresql-2011-09-30_000000.log | wc -l
38444
[root@homologacaosipac pg_log]# pgfouine.php -logtype=stderr -file
postgresql-2011-09-30_000000.log > sample_default.html
pgFouine did not find any valid PostgreSQL log line in your log file:
* check that PostgreSQL uses an english locale for logging (lc_messages in
your postgresql.conf),
* check that you use the -logtype option (syslog, stderr) according to your
log file,
* if you use syslog and log_line_prefix, check that your log_line_prefix has
a trailing space,
* if you use stderr, check that your log_line_prefix is of the form '%t
[%p]: [%l-1] '.
If you think your log file and your options are correct, please contact the
author (gsmet on #postgresql@freenode or guillaume-pg at smet dot org).
Em 29 de setembro de 2011 18:12, Dickson S. Guedes
<[email protected]>escreveu:
> Em 29 de setembro de 2011 18:07, Flavio Henrique Araque Gurgel
> <[email protected]> escreveu:
> >>> Bom, até onde eu lembro na expressão regular do pgfouine não espera
> >>> qualquer timezone, este BRT ai pode ser uma das causas, desde que o
> >>> resultado dos grep anteriores retornassem alguma coisa, o que nao
> >>> aconteceu.
> >
> > Eu faço pgFouine aqui com timezone sem problemas.
> > Acabei de gerar um do meu banco de produção aqui.
>
> Sim eu acabei de checar aqui... a primeira versão que eu utilizava
> tinha este problema, eu inclusive fazia alguns 'sed', a que estou
> utilizando no momento [1] não mais.
>
> > O que eu percebi é que o banco do Helio tem... 4 LINHAS! Certamente
> > não tem nada pro pgFouine olhar.
> > Hélio, manda carga e cata o log certo!
>
> +1.
>
>
> [1]
> http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/~checkout~/pgfouine/pgfouine/include/postgresql/PostgreSQLRegexps.lib.php?rev=1.15&content-type=text/plain
>
> --
> Dickson S. Guedes
> mail/xmpp: [email protected] - skype: guediz
> http://guedesoft.net - http://www.postgresql.org.br
> _______________________________________________
> pgbr-geral mailing list
> [email protected]
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>
--
--
Hélio José
(61) 99840139
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
