Обсуждение: looking to have 7.x behavior on 8.2/8.3

If I invoke postgres with -d5 every interaction gets dumped to the screen.

example:

postgres@database:~$ psql template1
Welcome to psql 7.4.7, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

template1=#


gets me this output:

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 ?

marc+psqlnoob@milestonerdl.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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +