Re: [SQL] log file - Mailing list pgsql-admin

From Josh Berkus
Subject Re: [SQL] log file
Date
Msg-id web-74539@davinci.ethosmedia.com
Whole thread Raw
List pgsql-admin
Richard, Jiang,

> I *think* you want DEBUG_PRINT_QUERY and its friends. See Ch 3.4.2 of
> the
> Administrators Guide.

Actually, Jiang need to re-start the postmaster with the command-line
options for logging set.  Annoyingly, the default init.d script for
Postgres in most RPMs starts Postgres without any logging.

Unfortunately, I'm at a remote terminal right now, so I can't post an
example.

-Josh Berkus


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

pgsql-admin by date:

Previous
From: "David M. Richter"
Date:
Subject: Posgres 7.1.2 and IRIX 6.4
Next
From: "Richard Huxton"
Date:
Subject: Re: [SQL] log file