É pessoal ainda não consegui ainda to mesmo erro, fiz tds alteraçãoes
sugeridas por vcs (Dickson e Flavio).
mesmo erro chato....abaixo segue o comando pra gerar o relatório e
o postgresql.conf:
[root@homologacaosipac pg_log]# *pgfouine.php -logtype=stderr -file
postgresql-2011-09-29_165752.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).
**
*# -----------------------------
# PostgreSQL configuration file
# -----------------------------
#
# This file consists of lines of the form:
#
# name = value
#
# (The "=" is optional.) Whitespace may be used. Comments are introduced
with
# "#" anywhere on a line. The complete list of parameter names and allowed
# values can be found in the PostgreSQL documentation.
#
# The commented-out settings shown in this file represent the default
values.
# Re-commenting a setting is NOT sufficient to revert it to the default
value;
# you need to reload the server.
#
# This file is read on server startup and when the server receives a SIGHUP
# signal. If you edit the file on a running system, you have to SIGHUP the
# server for the changes to take effect, or use "pg_ctl reload". Some
# parameters, which are marked below, require a server shutdown and restart
to
# take effect.
#
# Any parameter can also be given as a command-line option to the server,
e.g.,
# "postgres -c log_connections=on". Some parameters can be changed at run
time
# with the "SET" SQL command.
#
# Memory units: kB = kilobytes Time units: ms = milliseconds
# MB = megabytes s = seconds
# GB = gigabytes min = minutes
# h = hours
# d = days*
*
#------------------------------------------------------------------------------
# FILE LOCATIONS
#------------------------------------------------------------------------------
*
*# The default values of these variables are driven from the -D command-line
# option or PGDATA environment variable, represented here as ConfigDir.*
*#data_directory = 'ConfigDir' # use data in another directory
# (change requires restart)
#hba_file = 'ConfigDir/pg_hba.conf' # host-based authentication file
# (change requires restart)
#ident_file = 'ConfigDir/pg_ident.conf' # ident configuration file
# (change requires restart)*
*# If external_pid_file is not explicitly set, no extra PID file is written.
#external_pid_file = '(none)' # write an extra PID file
# (change requires restart)
*
Em 29 de setembro de 2011 16:19, Flavio Henrique Araque Gurgel <
[email protected]> escreveu:
> > Flavio muito obrigado pelo esclarecimento,
> > mas ainda não consegui gerar o relatório, da uma olhada
> >
> > o comando:
> > pgfouine.php -file postgresql-2011-09-29_151136.log >
> sample_default.html
> > o erro:
> > 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
> > auth or (gsmet on #postgresql@freenode or guillaume-pg at smet dot org).
> > configuração:
> > log_directory = 'pg_log'
> > log_destination = 'stderr'
> > logging_collector = on
>
> Você está usando stderr e não syslog, tudo bem até aqui.
>
> > log_min_duration_statement = 1
> > log_line_prefix = '%t [%p]: [%l-1]'
>
> Falta um espaço no final, antes do apóstrofe.
>
> > terei mexer no lc_messages?
>
> Se seu PostgreSQL estiver logando em outro idioma que não o inglês, sim.
> Se seu log está logando [duração] ao invés de [duration] (abra o log
> com less ou vi pra olhar), você pode converter seu log com o sed:
> sed s/duração/duration/ postgresql-2011-09-29_151136.log > em_ingles.log
>
> Aí passa pro pgFouine assim:
> pgfouine.php -logtype=stderr -file postgresql-2011-09-29_151136.log >
> sample_default.html
>
> []s
> Flavio Gurgel
> _______________________________________________
> 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
