newbie here

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/

Responses

Browse pgsql-general by date

  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