Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C339B64FF8A for ; Thu, 17 Jul 2008 06:15:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 04518-04 for ; Thu, 17 Jul 2008 06:15:10 -0300 (ADT) X-Greylist: delayed 00:30:41.007283 by SQLgrey-1.7.6 Received: from phoenix.sby.dnet.net.id (zeus02.sby.dnet.net.id [202.148.7.49]) by postgresql.org (Postfix) with ESMTP id 2693D64FCDA for ; Thu, 17 Jul 2008 06:15:13 -0300 (ADT) Received: from phoenix.sby.dnet.net.id (localhost [127.0.0.1]) by phoenix.sby.dnet.net.id (Postfix) with ESMTP id B81112B873C for ; Thu, 17 Jul 2008 16:03:40 +0700 (WIT) Received: from neptunus.sby.dnet.net.id (neptunus.sby.dnet.net.id [202.148.11.37]) by phoenix.sby.dnet.net.id (Postfix) with ESMTP id A89CA2B8726 for ; Thu, 17 Jul 2008 16:03:40 +0700 (WIT) Received: from ijs.co.id (unknown [202.148.12.194]) by neptunus.sby.dnet.net.id (Postfix) with ESMTP id DA38697EE4 for ; Thu, 17 Jul 2008 15:44:27 +0700 (WIT) Received: from edp03 ([192.140.6.18]) by ijs.co.id (ijs.co.id [192.140.6.10]) (MDaemon.PRO.v6.8.5.R) with ESMTP id 46-md50000000006.tmp for ; Thu, 17 Jul 2008 15:45:32 +0700 Message-ID: <01a601c8e7e9$41ad45d0$12068cc0@edp03> Reply-To: "System/IJS - Joko" From: "System/IJS - Joko" To: Subject: log_statement at postgres.conf Date: Thu, 17 Jul 2008 15:43:59 +0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01A3_01C8E823.EDFDC5F0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-MDRemoteIP: 192.140.6.18 X-Return-Path: system@ijs.co.id X-MDaemon-Deliver-To: pgsql-performance@postgresql.org X-Spam-Processed: ijs.co.id, Thu, 17 Jul 2008 15:45:37 +0700 X-Virus-Scanned: ClamAV using ClamSMTP X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200807/138 X-Sequence-Number: 30738 This is a multi-part message in MIME format. ------=_NextPart_000_01A3_01C8E823.EDFDC5F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear all, After setting log_statement=3D'all' at postgres.conf, then i'm rebooting OS [freeBSD or CentOS], i can't find where log file created from log_statement=3D'all' = located... FYI, location of postgres.conf at /var/lib/pgsql/data/postgres.conf many thanks.. Regards, Joko [SYSTEM] PT. Indra Jaya Swastika Phone: +62 31 7481388 Ext 201 http://www.ijs.co.id -- If you have any problem with our services , please contact us at 70468146 or e-mail: helpdesk@ijs.co.id PT Indra Jaya Swastika | Jl. Kalianak Barat 57A | +62-31-7481388 ------=_NextPart_000_01A3_01C8E823.EDFDC5F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dear all,
 
After setting log_statement=3D'all' = at=20 postgres.conf,
then i'm rebooting OS [freeBSD or=20 CentOS],
i can't find where log file created = from=20 log_statement=3D'all' located...
FYI, location of postgres.conf at=20 /var/lib/pgsql/data/postgres.conf
 
many thanks..
 
Regards,
Joko [SYSTEM]
PT. = Indra Jaya=20 Swastika
Phone: +62 31 7481388  Ext 201
http://www.ijs.co.id

--
If you have any problem with our services ,
please contact us at 70468146 or e-mail: helpdesk@ijs.co.id
PT Indra Jaya Swastika | Jl. Kalianak Barat 57A | +62-31-7481388 ------=_NextPart_000_01A3_01C8E823.EDFDC5F0--