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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-