Solved: Re: Logging queries

Madison Kelly wrote:
> Madison Kelly wrote:
>> 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
>>
>
> Oops, should have mentioned that I'm running 7.4.7 on Debian Sarge stable.
>
> Madison
>

For the love of... >.<

   I found the answer right after posting... Just had to set
'log_min_duration_statement' in 'postgres.conf' to '0'.

Sorry for the line noise! ^.^;

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