Re: Logging question

From: Tony Caduto <tony(dot)caduto(at)amsoftwaredesign(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Logging question
Date: 2005-01-18 03:13:19
Message-ID: 41EC7ECF.2040205@amsoftwaredesign.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael,
This is great info, is there a way to get the log back via a SQL call?
It would be pretty cool if there was a way to have the log go to a table
instead of a file.

Tony Caduto

Michael Fuhr wrote:

>
>ALTER USER johndoe SET log_statement TO TRUE; -- 7.x
>ALTER USER johndoe SET log_statement TO 'all'; -- 8.0
>
>All new connections that johndoe makes will now have statement
>logging enabled.
>
>To enable logging for a particular session, execute the appropriate
>"SET log_statement" statement in that session. If you have permission
>problems then you could wrap that operation in a function defined
>as SECURITY DEFINER and create the function as a database superuser.
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message William Yu 2005-01-18 03:14:37 Re: ext3
Previous Message Paul Tillotson 2005-01-18 03:06:20 Re: Logging question