From: | "Shevland, Joseph (AU - Hobart)" <jshevland(at)deloitte(dot)com(dot)au> |
---|---|
To: | "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | DEBUG output w/o debug set |
Date: | 2002-02-12 06:15:02 |
Message-ID: | CDDF6190494B6648934181A2719E72C102733A41@ausyd0405.au.deloitte.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I've recently installed Postgres 7.2, but this also applied to the 7.1.3
installation I had too. I'm seeing a lot of DEBUG messages being output to
the logfile/syslog, both when PG starts and stops, and also during VACUUM
ANALYZE runs (w/o verbose mode turned on); I start/stop PG via something
like:
su -l $PGUSER -c "pg_ctl start -D '$PGDATA' -s -l $PGLOG"
and the analyze runs are done from cron like so:
su -l $PGUSER -c "/usr/local/pgsql/bin/vacuumdb --all --analyze"
In postgresql.conf, the relevant section looks like:
---
# Debug display
#silent_mode = false
log_connections = true
log_timestamp = true
log_pid = true
#debug_level = 0 # range 0-16
#debug_print_query = false
#debug_print_parse = false
#debug_print_rewritten = false
#debug_print_plan = false
#debug_pretty_print = false
# requires USE_ASSERT_CHECKING
#debug_assertions = true
---
which to mean says that there shouldn't be much debug output (level=0); I'm
OK with the connection messages. I've attached some examples of the messages
below if they're helpful. Is this something I have done, or something I can
turn off? Its mainly the analyze lines that fill the log up. I'd have a
quick grep at the code for DEBUG's but I'll have to wait till I get home.
Cheers,
Joe
-- DEBUG examples:
Feb 12 17:13:40 www postgres[32308]: [1] DEBUG: smart shutdown request
Feb 12 17:13:40 www postgres[32375]: [2] DEBUG: shutting down
Feb 12 17:13:42 www postgres[32375]: [3] DEBUG: database system is shut
down
Feb 12 17:14:01 www postgres[32398]: [1] DEBUG: database system was shut
down at 2002-02-12 17:13:42 EST
Feb 12 17:14:01 www postgres[32398]: [2] DEBUG: checkpoint record is at
0/2CA848
Feb 12 17:14:01 www postgres[32398]: [3] DEBUG: redo record is at 0/2CA848;
undo record is at 0/0; shutdown TRUE
Feb 12 17:14:01 www postgres[32398]: [4] DEBUG: next transaction id: 1795;
next oid: 16557
Feb 12 17:14:01 www postgres[32398]: [5] DEBUG: database system is ready
Feb 12 17:14:08 www postgres[32410]: [1] DEBUG: connection: host=[local]
user=postgres database=template1
Feb 12 17:14:08 www postgres[32412]: [1] DEBUG: connection: host=[local]
user=postgres database=postgres
Feb 12 17:14:08 www postgres[32412]: [2] DEBUG: --Relation pg_type--
Feb 12 17:14:08 www postgres[32412]: [3-1] DEBUG: Pages 2: Changed 0, Empty
0; Tup 143: Vac 0, Keep 0, UnUsed 1.
Feb 12 17:14:08 www postgres[32412]: [3-2] Total CPU 0.00s/0.00u sec
elapsed 0.00 sec.
Feb 12 17:14:08 www postgres[32412]: [4] DEBUG: Analyzing pg_type
Feb 12 17:14:08 www postgres[32412]: [5] DEBUG: --Relation pg_attribute--
Feb 12 17:14:08 www postgres[32412]: [6-1] DEBUG: Pages 11: Changed 0,
Empty 0; Tup 795: Vac 0, Keep 0, UnUsed 21.
Feb 12 17:14:08 www postgres[32412]: [6-2] Total CPU 0.00s/0.00u sec
elapsed 0.00 sec.
Feb 12 17:14:08 www postgres[32412]: [7] DEBUG: Analyzing pg_attribute
Feb 12 17:14:08 www postgres[32412]: [8] DEBUG: --Relation pg_class--
...
***********Confidentiality/Limited Liability Statement***************
Have the latest business news and in depth analysis delivered to your
desktop. Subscribe to "Insights", Deloitte's fortnightly email
business bulletin . . .
http://www.deloitte.com.au/preferences/preference.asp
This message contains privileged and confidential information intended
only for the use of the addressee named above. If you are not the
intended recipient of this message, you must not disseminate, copy or
take any action in reliance on it. If you have received this message
in error, please notify Deloitte Touche Tohmatsu immediately. Any
views expressed in this message are those of the individual sender,
except where the sender specifically states them to be the views of
Deloitte.
The liability of Deloitte Touche Tohmatsu, is limited by, and to the
extent of, the Accountants' Scheme under the Professional Standards
Act 1994 (NSW).
The sender cannot guarantee that this email or any attachment to it is free of computer viruses or other conditions which may damage or
interfere with data, hardware or software with which it might be used. It is sent on the strict condition that the user carries out and relies
on its own procedures for ensuring that its use will not interfere with the recipients systems and the recipient assumes all risk of use and
absolves the sender of all responsibility for any consequence of its use.
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2002-02-12 06:29:30 | Re: [HACKERS] Feature enhancement request : use of libgda in |
Previous Message | Peter Eisentraut | 2002-02-12 04:38:02 | Re: Maintaining the list of release changes |