From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | marc+psqlnoob(at)milestonerdl(dot)com |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: looking to have 7.x behavior on 8.2/8.3 |
Date: | 2008-09-06 20:14:54 |
Message-ID: | 200809062014.m86KEsK25039@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
marc+psqlnoob(at)milestonerdl(dot)com wrote:
> If I invoke postgres with -d5 every interaction gets dumped to the screen.
> 2008-09-05 01:34:44 [4421] DEBUG: ProcessQuery
> 2008-09-05 01:34:44 [4421] DEBUG: CommitTransactionCommand
> 2008-09-05 01:34:44 [4421] DEBUG: proc_exit(0)
> 2008-09-05 01:34:44 [4421] DEBUG: shmem_exit(0)
> 2008-09-05 01:34:44 [4421] DEBUG: exit(0)
> 2008-09-05 01:34:44 [4364] DEBUG: reaping dead processes
> 2008-09-05 01:34:44 [4364] DEBUG: child process (PID 4421) exited with exit code 0
> 2008-09-05 01:34:44 [4429] LOG: connection received: host=[local] port=
> 2008-09-05 01:34:44 [4364] DEBUG: forked new backend, pid=4429 socket=9
> 2008-09-05 01:34:44 [4429] LOG: connection authorized: user=postgres database=template1
> 2008-09-05 01:34:44 [4429] DEBUG: /usr/lib/postgresql/bin/postmaster child[4429]: starting with (
> 2008-09-05 01:34:44 [4429] DEBUG: postgres
> 2008-09-05 01:34:44 [4429] DEBUG: -d5
> 2008-09-05 01:34:44 [4429] DEBUG: -v196608
> 2008-09-05 01:34:44 [4429] DEBUG: -p
> 2008-09-05 01:34:44 [4429] DEBUG: template1
> 2008-09-05 01:34:44 [4429] DEBUG: )
> 2008-09-05 01:34:44 [4429] DEBUG: InitPostgres
>
>
> How do I get that behavior on 8.2.x/8.3.x ?
client_min_messsage or log_min_messages will do this if set to
debug5.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Brad Nicholson | 2008-09-08 20:36:49 | Re: Problem wth postgresql.conf |
Previous Message | Bruce Momjian | 2008-09-06 19:34:21 | Re: telnet examples |