Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 716F164FF7A for ; Thu, 17 Jul 2008 06:52:02 -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 39598-02 for ; Thu, 17 Jul 2008 06:51:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smadev.internal.net (host3.dynacom.ondsl.gr [62.103.35.211]) by postgresql.org (Postfix) with ESMTP id CA4E464FF77 for ; Thu, 17 Jul 2008 06:51:57 -0300 (ADT) Received: from smadev.internal.net (localhost [127.0.0.1]) by smadev.internal.net (8.14.2/8.14.2) with ESMTP id m6H9polQ057539; Thu, 17 Jul 2008 12:51:50 +0300 (EEST) (envelope-from achill@matrix.gatewaynet.com) Received: from localhost (localhost [[UNIX: localhost]]) by smadev.internal.net (8.14.2/8.14.2/Submit) id m6H9pmR1057538; Thu, 17 Jul 2008 12:51:48 +0300 (EEST) (envelope-from achill@matrix.gatewaynet.com) From: Achilleas Mantzios Organization: Dynacom Tankers Mgmt To: pgsql-admin@postgresql.org, "System/IJS - Joko" Subject: Re: log_statement at postgres.conf Date: Thu, 17 Jul 2008 12:51:47 +0300 User-Agent: KMail/1.9.7 References: <018d01c8e7e9$2f7f5790$12068cc0@edp03> In-Reply-To: <018d01c8e7e9$2f7f5790$12068cc0@edp03> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200807171251.48345.achill@matrix.gatewaynet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200807/153 X-Sequence-Number: 29763 =CE=A3=CF=84=CE=B9=CF=82 Thursday 17 July 2008 11:43:28 =CE=BF/=CE=B7 Syste= m/IJS - Joko =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5: > Dear all, >=20 > 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 >=20 it is the log_destination variable which dictates that. > many thanks.. >=20 > Regards, > Joko [SYSTEM] > PT. Indra Jaya Swastika > Phone: +62 31 7481388 Ext 201 > http://www.ijs.co.id >=20 > -- > 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 >=20 =2D-=20 Achilleas Mantzios