Search Postgresql Archives

Solved: Re: Logging queries

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux