Logging queries

Hi all,

   I've got a machine I am setting up (read; low volume atm). I need a
way to log all the queries made to Postgres (just for a short time).

   I've got a problem with a 3rd party program (OSS, but I'm not 'let'
enough to trace it) and I am hoping to help fix the problem by being
able to see what query it is exactly trying to do.

   I remember once long ago I did this but I'll be dumb-struck if I can
remember how.

   As an aside;

   I've got a user named 'madison' who is in postgres and owns another
database which is working fine with one of my programs. So I know the
user is okay. I've created a new database and I am trying to tell this
program to connect to the new database as this user (local machine) but
I keep getting the error:

2006-02-02 23:07:36 [21958] LOG:  connection received: host=127.0.0.1
port=33387
2006-02-02 23:07:36 [21958] FATAL:  IDENT authentication failed for user
"madison"
2

   I've tried changing the 'pg_hba.conf' file from 'ident sameuser' to
'trust'' with no love, too.

   I'm hoping that seeing the query this program is using might help me
solve this problem.

   Thanks!!

Madison

--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
           Madison Kelly (Digimer)
    TLE-BU; The Linux Experience, Back Up
Main Project Page:  http://tle-bu.org
Community Forum:    http://forum.tle-bu.org
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-