From system@ijs.co.id Thu Jul  17 09:15:21 2008
Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id D17DC64FF92
	for <pgsql-admin-postgresql.org@postgresql.org>;
	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 05569-02 for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 17 Jul 2008 06:15:10 -0300 (ADT)
X-Greylist: from auto-whitelisted 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 2A73864FCE4
	for <pgsql-admin@postgresql.org>; 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 023432B86F6
	for <pgsql-admin@postgresql.org>; Thu, 17 Jul 2008 16:02:34 +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 DF45F2B85CC
	for <pgsql-admin@postgresql.org>; Thu, 17 Jul 2008 16:02:34 +0700 (WIT)
Received: from ijs.co.id (unknown [202.148.12.194])
	by neptunus.sby.dnet.net.id (Postfix) with ESMTP id 450C697EE3
	for <pgsql-admin@postgresql.org>; Thu, 17 Jul 2008 15:43:22 +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 45-md50000000006.tmp
	for <pgsql-admin@postgresql.org>; Thu, 17 Jul 2008 15:45:02 +0700
Message-ID: <018d01c8e7e9$2f7f5790$12068cc0@edp03>
Reply-To: "System/IJS - Joko" <system@ijs.co.id>
From: "System/IJS - Joko" <system@ijs.co.id>
To: <pgsql-admin@postgresql.org>
Subject: log_statement at postgres.conf
Date: Thu, 17 Jul 2008 15:43:28 +0700
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_018A_01C8E823.DBD248B0"
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-admin@postgresql.org
X-Spam-Processed: ijs.co.id, Thu, 17 Jul 2008 15:45:07 +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/151
X-Sequence-Number: 29761

This is a multi-part message in MIME format.

------=_NextPart_000_018A_01C8E823.DBD248B0
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_018A_01C8E823.DBD248B0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.5730.13" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#fffbf0>
<DIV><FONT face=3DVerdana size=3D2>Dear all,</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DVerdana size=3D2>After setting log_statement=3D'all' =
at=20
postgres.conf,</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2>then i'm rebooting OS [freeBSD or=20
CentOS],</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2>i can't find where log file created =
from=20
log_statement=3D'all' located...</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2>FYI, location of postgres.conf at=20
/var/lib/pgsql/data/postgres.conf</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DVerdana size=3D2>many thanks..</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DVerdana size=3D2>Regards,<BR>Joko [SYSTEM]<BR>PT. =
Indra Jaya=20
Swastika<BR>Phone: +62 31 7481388&nbsp; Ext 201<BR><A=20
href=3D"http://www.ijs.co.id">http://www.ijs.co.id</A></FONT></DIV></BODY=
></HTML>


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

------=_NextPart_000_018A_01C8E823.DBD248B0--




From achill@matrix.gatewaynet.com Thu Jul  17 09:52:02 2008
Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 716F164FF7A
	for <pgsql-admin-postgresql.org@postgresql.org>;
	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 <pgsql-admin-postgresql.org@postgresql.org>;
	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 <pgsql-admin@postgresql.org>; 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 <achill@matrix.gatewaynet.com>
Organization: Dynacom Tankers Mgmt
To: pgsql-admin@postgresql.org, "System/IJS - Joko" <system@ijs.co.id>
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



From rexmabry@yahoo.com Thu Jul  17 13:33:24 2008
Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 03E6864FD64
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 17 Jul 2008 10:33:24 -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 38094-02 for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 17 Jul 2008 10:33:14 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from web35905.mail.mud.yahoo.com (web35905.mail.mud.yahoo.com
	[66.163.179.189])
	by postgresql.org (Postfix) with SMTP id 299E864FCEE
	for <pgsql-admin@postgresql.org>; Thu, 17 Jul 2008 10:33:20 -0300 (ADT)
Received: (qmail 33241 invoked by uid 60001); 17 Jul 2008 13:33:18 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID;
	b=G6Q0DBBYVzMGzS3vdRUO/IsxzbwAHA6WD6yi0mWyjd8CYHpUBkCCx4LztnybhhuSqsBtyrFzMvxVBTDirZ9oo6zBVl2mD7A2pyr0xLNVmVqU+psdpwcyxEIQOCZ1goTWdCN/gdLRFNGN9m93McKSeB6OB0pbGehj7FTNYjCaizc=;
Received: from [199.200.10.52] by web35905.mail.mud.yahoo.com via HTTP;
	Thu, 17 Jul 2008 06:33:18 PDT
X-Mailer: YahooMailWebService/0.7.218
Date: Thu, 17 Jul 2008 06:33:18 -0700 (PDT)
From: Rex Mabry <rexmabry@yahoo.com>
Reply-To: rexmabry@yahoo.com
Subject: Re: log_statement at postgres.conf
To: pgsql-admin@postgresql.org
In-Reply-To: <200807171251.48345.achill@matrix.gatewaynet.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-728743529-1216301598=:33012"
Message-ID: <443728.33012.qm@web35905.mail.mud.yahoo.com>
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/154
X-Sequence-Number: 29764

--0-728743529-1216301598=:33012
Content-Type: text/plain; charset=iso-8859-7
Content-Transfer-Encoding: quoted-printable

Inside the database, you can query the pg_settings table.
=A0
select * from pg_catalog.pg_settings where name =3D 'log_directory';
=A0
To see other stuff you can get from that table, try:
=A0
select name from pg_catalog.pg_settings;

--- On Thu, 7/17/08, Achilleas Mantzios <achill@matrix.gatewaynet.com> wrot=
e:

From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Subject: Re: [ADMIN] log_statement at postgres.conf
To: pgsql-admin@postgresql.org, "System/IJS - Joko" <system@ijs.co.id>
Date: Thursday, July 17, 2008, 4:51 AM

=D3=F4=E9=F2 Thursday 17 July 2008 11:43:28 =EF/=E7 System/IJS - Joko =DD=
=E3=F1=E1=F8=E5:
> 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



--=20
Achilleas Mantzios

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin=0A=0A=0A      
--0-728743529-1216301598=:33012
Content-Type: text/html; charset=iso-8859-7
Content-Transfer-Encoding: quoted-printable

<table cellspacing=3D'0' cellpadding=3D'0' border=3D'0' ><tr><td valign=3D'=
top' style=3D'font: inherit;'><P>Inside the database, you can query the pg_=
settings table.</P>
<P>&nbsp;</P>
<P>select * from pg_catalog.pg_settings where name =3D 'log_directory';</P>
<P>&nbsp;</P>
<P>To see other stuff you can get from that table, try:</P>
<P>&nbsp;</P>
<P>select name from pg_catalog.pg_settings;<BR><BR>--- On <B>Thu, 7/17/08, =
Achilleas Mantzios <I>&lt;achill@matrix.gatewaynet.com&gt;</I></B> wrote:<B=
R></P>
<BLOCKQUOTE style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(=
16,16,255) 2px solid">From: Achilleas Mantzios &lt;achill@matrix.gatewaynet=
.com&gt;<BR>Subject: Re: [ADMIN] log_statement at postgres.conf<BR>To: pgsq=
l-admin@postgresql.org, "System/IJS - Joko" &lt;system@ijs.co.id&gt;<BR>Dat=
e: Thursday, July 17, 2008, 4:51 AM<BR><BR><PRE>=D3=F4=E9=F2 Thursday 17 Ju=
ly 2008 11:43:28 =EF/=E7 System/IJS - Joko =DD=E3=F1=E1=F8=E5:
&gt; Dear all,
&gt;=20
&gt; After setting log_statement=3D'all' at postgres.conf,
&gt; then i'm rebooting OS [freeBSD or CentOS],
&gt; i can't find where log file created from log_statement=3D'all'
located...
&gt; FYI, location of postgres.conf at /var/lib/pgsql/data/postgres.conf
&gt;=20
it is the log_destination variable which dictates that.
&gt; many thanks..
&gt;=20
&gt; Regards,
&gt; Joko [SYSTEM]
&gt; PT. Indra Jaya Swastika
&gt; Phone: +62 31 7481388  Ext 201
&gt; http://www.ijs.co.id
&gt;=20
&gt; --
&gt; If you have any problem with our services ,
&gt; please contact us at 70468146 or e-mail: helpdesk@ijs.co.id
&gt; PT Indra Jaya Swastika | Jl. Kalianak Barat 57A | +62-31-7481388
&gt;=20



--=20
Achilleas Mantzios

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin</PRE></BLOCKQUOTE></td></tr>=
</table><br>=0A=0A      
--0-728743529-1216301598=:33012--