Postgresql logging_collector = off ignored ?

From: Ludwik Dylag <ldylag(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Postgresql logging_collector = off ignored ?
Date: 2009-11-28 14:54:35
Message-ID: 2fe468a20911280654k3066c4a9ud58e51cae3bf467d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello all.
I have installed postgreslq 8.3 on Ubuntu linux.
My postgresql.conf file is:
data_directory = '/home/postgres/8.3/main' # use data in
another directory
hba_file = '/etc/postgresql/8.3/main/pg_hba.conf' # host-based
authentication file
ident_file = '/etc/postgresql/8.3/main/pg_ident.conf' # ident
configuration file
external_pid_file = '/var/run/postgresql/8.3-main.pid' # write an
extra PID file
max_connections = 140 # (change requires restart)
shared_buffers = 128MB # min 128kB or max_connections*16kB
maintenance_work_mem = 512MB # min 1MB
max_fsm_pages = 1500000 # min max_fsm_relations*16, 6 bytes
each
max_fsm_relations = 2000 # min 100, ~70 bytes each
checkpoint_segments = 30 # in logfile segments, min 1, 16MB
each
log_destination = 'stderr' # Valid values are combinations of
logging_collector = off # Enable capturing of stderr and csvlog
log_rotation_size = 1GB # Automatic rotation of logfiles will
log_connections = on
log_min_error_statement = PANIC
log_line_prefix = '%m %p %u %d %r ' # special values:
log_lock_waits = on # log lock waits >= deadlock_timeout
log_statement = 'ddl' # none, ddl, mod, all
log_temp_files = 4096 # log temporary files equal or
larger
autovacuum = on # Enable autovacuum subprocess? 'on'
autovacuum_max_workers = 1 # max number of autovacuum
subprocesses
autovacuum_freeze_max_age = 2000000000 # maximum XID age before forced
vacuum
lc_messages = 'en_US.utf8' # locale for system error
message
lc_monetary = 'en_US.utf8' # locale for monetary
formatting
lc_numeric = 'en_US.utf8' # locale for number
formatting
lc_time = 'en_US.utf8' # locale for time formatting
deadlock_timeout = 1s

And I expect postgres not to produce any logs.
Unfortunately I keep getting new logs in
/var/log/postgresql/postgresql-8.3-main.log.
First of all I expected logs to be written in PGDATA/pg_log directory.
How can I redirect them to this location?
Secondly I want to be able to switch them off. What makes postgresql write
logs to /var/log/postgresql/postgresql-8.3-main.log when logging (I think)
is switched off?

Thanks in advance for help.
Ludwik

--
Ludwik Dyląg

Browse pgsql-admin by date

  From Date Subject
Next Message rahimeh khodadadi 2009-11-29 05:43:37 some errors with using Kerberos authentication in PSQL
Previous Message Jaime Casanova 2009-11-27 04:44:39 Re: WAL file compatibility