Logging problems in PostgreSQL 7.2devel

From: John Summerfield <pgtest(at)os2(dot)ami(dot)com(dot)au>
To: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Logging problems in PostgreSQL 7.2devel
Date: 2001-09-04 00:34:16
Message-ID: Pine.LNX.4.33.0109040827370.20458-100000@dugite.os2.ami.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I have postmaster configured to use syslog. Despite this, these messages appear on the terminal from which I start it:
2001-09-03 23:44:37 [26371] DEBUG: recycled transaction log file 0000000000000044

There are many of those.

Here are the relevant lines from the configuration:
[pgtest(at)possum pgtest]$ egrep -v '(^#|^$)' /var/share/pgtest/postgresql/pgsql/data/postgresql.conf
tcpip_socket = true
show_source_port = true
shared_buffers = 1024 # 2*max_connections, min 16
wal_files = 4 # range 0-64
wal_sync_method = fsync # fsync or fdatasync or open_sync or open_datasync
wal_debug = 0 # range 0-16
log_connections = true
log_timestamp = true
log_pid = true
debug_level = 0 # range 0-16
debug_assertions = true
syslog = 2 # range 0-2
[pgtest(at)possum pgtest]$

Additionally there are many (supposedly suppressed) (apparently) debugging lines printed out on syslog:
Sep 3 20:42:10 possum postgres[26215]: [1] DEBUG: connection: host=192.168.1.6:32923 user=summer database=sharetrader
Sep 3 20:42:10 possum postgres[26215]: [2] ERROR: index "ijs0101_stocks_info" does not exist
Sep 3 20:42:47 possum postgres[26229]: [1] DEBUG: connection: host=192.168.1.6:32924 user=summer database=sharetrader
Sep 3 20:42:47 possum postgres[26229]: [2] ERROR: index "ijs0102_trades" does not exist
Sep 3 20:42:47 possum postgres[26229]: [3] ERROR: table "tjs0102_trades" does not exist
Sep 3 20:42:47 possum postgres[26229]: [4] NOTICE: CREATE TABLE/UNIQUE will create implicit index 'tjs0102_trades_asx_key' for table 'tjs0102_trades'
Sep 3 20:44:22 possum postgres[26270]: [1] DEBUG: recycled transaction log file 0000000000000002
Sep 3 20:49:27 possum postgres[26271]: [1] DEBUG: recycled transaction log file 0000000000000003

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-09-04 02:37:11 Re: Error in backend/storage/lmgr/proc.c: ProcSleep()
Previous Message Stephan Szabo 2001-09-04 00:08:53 Re: Odp: PD: triggered data change violation on relation