Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 696569FB2A2 for ; Wed, 17 Jan 2007 14:04:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 06869-06 for ; Wed, 17 Jan 2007 14:03:19 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.238]) by postgresql.org (Postfix) with ESMTP id 8A5C09FB2A5 for ; Wed, 17 Jan 2007 14:03:19 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id i11so506393nzh for ; Wed, 17 Jan 2007 10:03:18 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Nmvh1tlKzWZCLI63M1NKYn0IoWxA98lOOU07yRxbzSKvULv1NdcGRVzQHVIm4XUfVf/r7YXQ4hnNDApqgN3ivXWceGfn6kaY6OP1aKedzKSQq4xjUIPkOaq3MRfgngqSvEr7JQDV58gg92OJwr4Ap8xqrHuE6kgyRgq1giWdxko= Received: by 10.64.241.3 with SMTP id o3mr10521079qbh.1169056998244; Wed, 17 Jan 2007 10:03:18 -0800 (PST) Received: by 10.65.188.5 with HTTP; Wed, 17 Jan 2007 10:03:18 -0800 (PST) Message-ID: Date: Wed, 17 Jan 2007 23:03:18 +0500 From: "Shoaib Mir" To: "Joshua D. Drake" Subject: Re: Monitoring Transaction Log size Cc: "Ziegelwanger, Silvio" , pgsql-performance@postgresql.org In-Reply-To: <45AE6376.7060606@commandprompt.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_74329_20723072.1169056998104" References: <45AE6376.7060606@commandprompt.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/266 X-Sequence-Number: 22867 ------=_Part_74329_20723072.1169056998104 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline archive_timeout (came in ver 8.2) might help you with customizing the size for log files. ----------------- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 1/17/07, Joshua D. Drake wrote: > > Ziegelwanger, Silvio wrote: > > Hi, > > > > > > > > how can I monitor the size of the transaction log files using SQL > Statements? > > You can't. You would have to write a custom function to heck the size of > the xlog directory. > > Sincerely, > > Joshua D. Drake > > > > > > > > > Best Regards > > > > > > > > Silvio > > > > > > > > Silvio Ziegelwanger > > Research & Development > > > > Fabalabs Software GmbH > > Honauerstra=DFe 4 > > 4020 Linz > > Austria > > Tel: [43] (732) 60 61 62 > > Fax: [43] (732) 60 61 62-609 > > E-Mail: silvio.ziegelwanger@fabasoft.com > > www.fabasoft.com > > > > < > http://www.fabasoft.at/fabasofthomepage2006/fabasoftgruppe/veranstaltunge= n/fabasoftegovdays07.htm > > > > > > Fabasoft egovday 07 > > Trends im E-Government, Innovationen f=FCr eine > > zukunftsorientierte Verwaltung und digitale Gesch=E4ftsprozesse. > > > > 23. Januar 2007, Bern > > > > 30. Januar 2007, Berlin > > > > 6. Februar 2007, Bonn > > > > > > > > > > > -- > > =3D=3D=3D The PostgreSQL Company: Command Prompt, Inc. =3D=3D=3D > Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 > Providing the most comprehensive PostgreSQL solutions since 1997 > http://www.commandprompt.com/ > > Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate > PostgreSQL Replication: http://www.commandprompt.com/products/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate > ------=_Part_74329_20723072.1169056998104 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline archive_timeout (came in ver 8.2) might help you with customizing the size = for log files.

-----------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)


On 1/17/07, = Joshua D. Drake <jd@commandp= rompt.com> wrote:
Ziegelwanger, Silvio wrote:
> Hi,
>
>
>
> how= can I monitor the size of the transaction log files using SQL Statements?<= br>
You can't. You would have to write a custom function to heck the= size of
the xlog directory.

Sincerely,

Joshua D. Drake

>= ;
>
>
> Best Regards
>
>
>
> Silv= io
>
>
>
> Silvio Ziegelwanger
> Research &am= p; Development
>
> Fabalabs Software GmbH
> Honauerstra=DFe 4
> 4= 020 Linz
> Austria
> Tel: [43] (732) 60 61 62
> Fax: [43]= (732) 60 61 62-609
> E-Mail: silvio.ziegelwanger@fabasoft.com
> www.fabasoft.com <http://= www.fabasoft.com/>
>
>   < http://www.fabasoft.at/fabasofthomepage2006/fabasoftgruppe/veranstaltungen/= fabasoftegovdays07.htm>
>
> Fabasoft egovday 07
> = Trends im E-Government, Innovationen f=FCr eine
> zukunftsorientierte= Verwaltung und digitale Gesch=E4ftsprozesse.
>
> 23. Januar 2007, Bern
>
> 30. Januar 2007, Ber= lin
>
> 6. Februar 2007, Bonn
>
>
>
>

--

      =3D=3D=3D The Postg= reSQL Company: Command Prompt, Inc. =3D=3D=3D
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Pr= oviding the most comprehensive  PostgreSQL solutions since 1997             = http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
Postgre= SQL Replication: http://= www.commandprompt.com/products/


---------------------------(end of broadcast)--------------= -------------
TIP 7: You can help support the PostgreSQL project by dona= ting at

          =        http://www.postgresql.org/about/donate

------=_Part_74329_20723072.1169056998104--