Hi all,
I'm using postgresql version 8.1 on FREEBSD 6.x
some info ---------
bash-2.05b# pkg_info | grep post
postgresql-client-8.1.4 PostgreSQL database (client)
postgresql-docs-8.1.4 The PostgreSQL documentation set
postgresql-relay-1.3.1 Multiplex multiple PostgreSQL databases to one relay
postgresql-server-8.1.4 The most advanced open-source database available anywhere
bash-2.05b#
------------------------
i've already configured the file postgresql.conf (at /usr/local/pgsql/data path)
to send te log to /var/log/pgsql/ directory and it's working but How can I get more info on the log file
I need to get the erros generated by php sessions or requests generetad by my web server
regards,
--- postgresql.conf ---
without #commented lines
max_connections = 40
shared_buffers = 1000 # min 16 or max_connections*2, 8KB each
log_destination = 'syslog'
#log_destination = 'stderr' # Valid values are combinations of
log_destination = 'stderr' # Valid values are combinations of
# stderr, syslog and eventlog,
# depending on platform.
redirect_stderr = on # Enable capturing of stderr into log
log_directory = '/var/log/pgsql/' # Directory where log files are written
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # Log file name pattern.
log_rotation_age = 1440 # Automatic rotation of logfiles will
log_rotation_size = 10240 # Automatic rotation of logfiles will
client_min_messages = log # Values, in order of decreasing detail:
log_min_messages = notice # Values, in order of decreasing detail:
log_error_verbosity = default # terse, default, or verbose messages
silent_mode = on
log_connections = on
log_disconnections = on
log_line_prefix = '%u %d %h %r %i' # Special values:
log_statement = 'all' # none, mod, ddl, all
log_hostname = on
-----
Thiago Beier
__________________________________________________
Fale com seus amigos de graça com o novo Yahoo! Messenger
http://br.messenger.yahoo.com/
