Horton

Re: [GENERAL] Trace postgresql

Bruce Momjian <maillist@candle.pha.pa.us>

View thread View on postgr.es
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: Kevin Heflin <kheflin@shreve.net>
Cc: "PGSQL-General (E-mail)" <pgsql-general@postgreSQL.org>
Date: 1999-08-24T04:46:18Z
Lists: pgsql-general 
> 
> Is there any type of trace function or any logs that can be created and
> viewed that show any/all sql sent to postgres and the results?
> 
> Kevin

Sure, use -d flags to postgres backend and postmaster.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026