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--