Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 475EA475FC5
	for <pgsql-interfaces@postgresql.org>;
	Mon, 21 Oct 2002 01:21:59 -0400 (EDT)
Received: from accord1.ads4globe.net (unknown [203.197.88.22])
	by postgresql.org (Postfix) with ESMTP id A87F8475FEB
	for <pgsql-interfaces@postgresql.org>;
	Mon, 21 Oct 2002 01:21:56 -0400 (EDT)
Received: from uday ([61.11.21.122])
	by accord1.ads4globe.net (8.11.6/8.11.6) with SMTP id g9L4mTe22103
	for <pgsql-interfaces@postgresql.org>; Mon, 21 Oct 2002 10:18:30 +0530
Message-ID: <006c01c278c2$9bbdf020$2664a8c0@uday>
From: "Uday" <uday@accord.co.in>
To: <pgsql-interfaces@postgresql.org>
Subject: PGLOG problem
Date: Mon, 21 Oct 2002 10:57:46 +0530
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0063_01C278F0.B038ECC0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/66
X-Sequence-Number: 3228

This is a multi-part message in MIME format.

------=_NextPart_000_0063_01C278F0.B038ECC0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

A simple question but since I'm not very conversant with PG if someone can =
help me about how to reduce the size of the "pg_log" file I have on my mail=
 server database.

I have a box with RH7.1 for the mail server and a PG database for the mail =
users and a memory resident program which keeps on polling with the help of=
 the database.  This keeps on increasing the size of the pg_log (which goes=
 till probably the disk will be full) after which I suppose I will be in a =
total soup.

I tried deleting it once (obviously after taking backup) but then the syste=
m could not access the database and I had to restore the original.

Please all help will be welcomed before the system goes down.  Currently th=
e size of the "pg_log" is approx. 300MB.  So it is pretty urgent.

Thanks in advance

-Uday

------=_NextPart_000_0063_01C278F0.B038ECC0
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 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>A simple question but since I'm not very c=
onversant=20
with PG if someone can help me about how to reduce the size of the "pg_log"=
 file=20
I have on my mail server database.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I have a box with RH7.1 for the mail serve=
r and a=20
PG database for the mail users and a memory resident program which keeps on=
=20
polling with the help of the database.&nbsp; This keeps on increasing the s=
ize=20
of the pg_log (which goes till probably the disk will be full) after which =
I=20
suppose I will be in a total soup.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I tried deleting it once (obviously after =
taking=20
backup) but then the system could not access the database and I had to rest=
ore=20
the original.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Please all help will be welcomed before th=
e system=20
goes down.&nbsp; Currently the size of the "pg_log" is approx. 300MB.&nbsp;=
 So=20
it is pretty urgent.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>-Uday</FONT></DIV></BODY></HTML>

------=_NextPart_000_0063_01C278F0.B038ECC0--