Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004

    Exclamation Unanswered: Listing recent psql queries

    Hello everyone!

    Running Postgresql 7.4 (I think) in psql is it possible to view a list of the most recent queries run against a particular DB?

    I can get the most recent in .psql_history but this is for queries used in the psql monitor, I am after queries that were made against the system from the web sever or wwwrun user? Is this information logged or stored anywhere?

    Thanks All!

  2. #2
    Join Date
    Dec 2004
    Kharkov, Ukraine
    You can logged all queries.
    See part "Message display" and "Syslog" of your postgresql.conf for enable this functions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts