From: | Thiago Germano Beier <thiagog_beier(at)yahoo(dot)com(dot)br> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | newbie here |
Date: | 2006-07-27 23:52:45 |
Message-ID: | 20060727235245.3762.qmail@web54306.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | gustavo halperin | 2006-07-28 01:34:41 | Re: automatic and randomally population |
Previous Message | Ian Johnson | 2006-07-27 22:26:42 | Re: Can't start PostgreSQL |