From uday@accord.co.in Mon Oct  21 05:21:59 2002
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--





From tgl@sss.pgh.pa.us Mon Oct  21 13:14:12 2002
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id D470347658C
	for <pgsql-interfaces@postgresql.org>;
	Mon, 21 Oct 2002 09:14:12 -0400 (EDT)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP id 9702F4763E4
	for <pgsql-interfaces@postgresql.org>;
	Mon, 21 Oct 2002 09:10:18 -0400 (EDT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g9LD9vhR016421;
	Mon, 21 Oct 2002 09:09:57 -0400 (EDT)
To: "Uday" <uday@accord.co.in>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: PGLOG problem 
In-reply-to: <006c01c278c2$9bbdf020$2664a8c0@uday> 
References: <006c01c278c2$9bbdf020$2664a8c0@uday>
Comments: In-reply-to "Uday" <uday@accord.co.in>
	message dated "Mon, 21 Oct 2002 10:57:46 +0530"
Date: Mon, 21 Oct 2002 09:09:56 -0400
Message-ID: <16420.1035205796@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/67
X-Sequence-Number: 3229

"Uday" <uday@accord.co.in> writes:
> 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.

Update to PG 7.2.3.

			regards, tom lane



From awitney@sghms.ac.uk Fri Nov  29 12:12:44 2002
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 41AC1475DBD
	for <pgsql-interfaces@postgresql.org>;
	Fri, 29 Nov 2002 07:12:44 -0500 (EST)
Received: from mailhub2.sghms.ac.uk (firewall.sghms.ac.uk [194.82.50.2])
	by postgresql.org (Postfix) with ESMTP id 7E9DF475C15
	for <pgsql-interfaces@postgresql.org>;
	Fri, 29 Nov 2002 07:12:43 -0500 (EST)
Received: from [194.82.51.24] (helo=imail)
	by mailhub2.sghms.ac.uk with esmtp (Exim 4.05)
	id 18HjzQ-0004x9-00; Fri, 29 Nov 2002 12:11:24 +0000
Received: from [172.16.20.3] (mrc1-003.sghms.ac.uk [172.16.20.3])
	by imail.sghms.ac.uk
	(iPlanet Messaging Server 5.1 HotFix 0.7 (built May  7 2002))
	with ESMTPA id <0H6C008DE790QN@imail.sghms.ac.uk>; Fri,
	29 Nov 2002 12:12:37 +0000 (GMT)
Date: Fri, 29 Nov 2002 12:12:49 +0000
From: Adam Witney <awitney@sghms.ac.uk>
In-reply-to: <003501c297a1$0adbc8e0$2664a8c0@uday>
To: Uday <uday@accord.co.in>
Cc: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Message-id: <BA0D0A41.C8E4%a.witney@sghms.ac.uk>
MIME-version: 1.0
User-Agent: Microsoft-Entourage/10.1.1.2418
Subject: Re: PGLOG problem
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
X-Spam-Status: No, hits=-101.9 required=5.7
	tests=IN_REP_TO,QUOTED_EMAIL_TEXT,SPAM_PHRASE_00_01,
	TO_LOCALPART_EQ_REAL,USER_AGENT,USER_AGENT_ENTOURAGE,
	USER_IN_WHITELIST version=2.43
X-Spam-Level: 
X-MailScanner: Found to be clean
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/157
X-Sequence-Number: 3405


Try here

http://www.ca.postgresql.org/ftpsite/binary/v7.2.3/RPMS/


> I have searched all of the archive but nothing close.  Can you give me the
> exact link from where I can download PG 7.2.3. for my RH7.1 box on Intel
> PIII, as I was trying to google but there are so many downloads that Iam
> confused.
> 
> Thanks
> -Uday


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.




From uday@accord.co.in Fri Nov  29 12:09:57 2002
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 7059B475BD7
	for <pgsql-interfaces@postgresql.org>;
	Fri, 29 Nov 2002 07:09:57 -0500 (EST)
Received: from accord1.ads4globe.net (unknown [203.197.88.22])
	by postgresql.org (Postfix) with ESMTP id 2293B475AFF
	for <pgsql-interfaces@postgresql.org>;
	Fri, 29 Nov 2002 07:09:55 -0500 (EST)
Received: from uday ([61.11.20.2])
	by accord1.ads4globe.net (8.11.6/8.11.6) with SMTP id gATBWq822054;
	Fri, 29 Nov 2002 17:02:52 +0530
Message-ID: <003501c297a1$0adbc8e0$2664a8c0@uday>
From: "Uday" <uday@accord.co.in>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: <pgsql-interfaces@postgresql.org>
References: <006c01c278c2$9bbdf020$2664a8c0@uday>
	<16420.1035205796@sss.pgh.pa.us>
Subject: Re: PGLOG problem 
Date: Fri, 29 Nov 2002 17:45:31 +0530
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
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: 200211/156
X-Sequence-Number: 3404

I have searched all of the archive but nothing close.  Can you give me the
exact link from where I can download PG 7.2.3. for my RH7.1 box on Intel
PIII, as I was trying to google but there are so many downloads that Iam
confused.

Thanks
-Uday
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Uday" <uday@accord.co.in>
Cc: <pgsql-interfaces@postgresql.org>
Sent: Monday, October 21, 2002 6:39 PM
Subject: Re: [INTERFACES] PGLOG problem


> "Uday" <uday@accord.co.in> writes:
> > 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.
>
> Update to PG 7.2.3.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>





From uday@accord.co.in Tue Dec  31 09:14:36 2002
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 907584760F5
	for <pgsql-interfaces@postgresql.org>;
	Tue, 31 Dec 2002 04:14:36 -0500 (EST)
Received: from accord1.ads4globe.net (unknown [203.197.88.22])
	by postgresql.org (Postfix) with ESMTP id 9B37347600E
	for <pgsql-interfaces@postgresql.org>;
	Tue, 31 Dec 2002 04:14:34 -0500 (EST)
Received: from uday ([61.11.20.73])
	by accord1.ads4globe.net (8.11.6/8.11.6) with SMTP id gBV9Chw07926
	for <pgsql-interfaces@postgresql.org>; Tue, 31 Dec 2002 14:42:43 +0530
Message-ID: <003a01c2b0ad$d7599bc0$2664a8c0@uday>
From: "Uday" <uday@accord.co.in>
To: <pgsql-interfaces@postgresql.org>
Subject: Re: PGLOG problem
Date: Tue, 31 Dec 2002 14:50:19 +0530
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0037_01C2B0DB.F00E7180"
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: 200212/84
X-Sequence-Number: 3497

This is a multi-part message in MIME format.

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

Hi there

Finally I got all the RPMS for postgres 7.2.3-1 from
http://rpm.pbone.net/index.php3/stat/14/idka/4289/datan/2002-10-30  and
installed all the RPMS.  Now when I try to start postmaster I have this
following error:

postmaster: error while loading shared libraries: /usr/lib/libreadline.so.4:
undefined symbol: BC

Now if Iam not wrong - Do I have to load a new readline package?

If YES then which is the correct version which goes along with this postgres
(7.2.3-1) and where to get it from?


Thanx
-Uday



----- Original Message -----
From: "Adam Witney" <awitney@sghms.ac.uk>
To: "Uday" <uday@accord.co.in>
Cc: "pgsql-interfaces" <pgsql-interfaces@postgresql.org>
Sent: Friday, November 29, 2002 5:42 PM
Subject: Re: [INTERFACES] PGLOG problem


>
> Try here
>
> http://www.ca.postgresql.org/ftpsite/binary/v7.2.3/RPMS/
>
>
> > I have searched all of the archive but nothing close.  Can you give me
the
> > exact link from where I can download PG 7.2.3. for my RH7.1 box on Intel
> > PIII, as I was trying to google but there are so many downloads that Iam
> > confused.
> >
> > Thanks
> > -Uday
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.


------=_NextPart_000_0037_01C2B0DB.F00E7180
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><FONT face=3D"Times New Roman" size=3D3>Hi=
=20
there<BR><BR>Finally I got all the RPMS for postgres 7.2.3-1 from<BR></FONT=
><A=20
href=3D"http://rpm.pbone.net/index.php3/stat/14/idka/4289/datan/2002-10-30"=
><FONT=20
face=3D"Times New Roman"=20
size=3D3>http://rpm.pbone.net/index.php3/stat/14/idka/4289/datan/2002-10-30=
</FONT></A><FONT=20
face=3D"Times New Roman" size=3D3>&nbsp; and<BR>installed all the RPMS.&nbs=
p; Now=20
when I try to start postmaster I have this<BR>following=20
error:<BR><BR>postmaster: error while loading shared libraries:=20
/usr/lib/libreadline.so.4:<BR>undefined symbol: BC<BR><BR>Now if Iam not wr=
ong -=20
Do I have to load a new readline package?<BR><BR>If YES then which is the=
=20
correct version which goes along with this postgres<BR>(7.2.3-1) and where =
to=20
get it from?<BR><BR><BR>Thanx<BR>-Uday<BR><BR><BR><BR>----- Original Messag=
e=20
-----<BR>From: "Adam Witney" &lt;</FONT><A=20
href=3D"mailto:awitney@sghms.ac.uk"><FONT face=3D"Times New Roman"=20
size=3D3>awitney@sghms.ac.uk</FONT></A><FONT face=3D"Times New Roman"=20
size=3D3>&gt;<BR>To: "Uday" &lt;</FONT><A href=3D"mailto:uday@accord.co.in"=
><FONT=20
face=3D"Times New Roman" size=3D3>uday@accord.co.in</FONT></A><FONT=20
face=3D"Times New Roman" size=3D3>&gt;<BR>Cc: "pgsql-interfaces" &lt;</FONT=
><A=20
href=3D"mailto:pgsql-interfaces@postgresql.org"><FONT face=3D"Times New Rom=
an"=20
size=3D3>pgsql-interfaces@postgresql.org</FONT></A><FONT face=3D"Times New =
Roman"=20
size=3D3>&gt;<BR>Sent: Friday, November 29, 2002 5:42 PM<BR>Subject: Re:=20
[INTERFACES] PGLOG problem<BR><BR><BR>&gt;<BR>&gt; Try here<BR>&gt;<BR>&gt;=
=20
</FONT><A href=3D"http://www.ca.postgresql.org/ftpsite/binary/v7.2.3/RPMS/"=
><FONT=20
face=3D"Times New Roman"=20
size=3D3>http://www.ca.postgresql.org/ftpsite/binary/v7.2.3/RPMS/</FONT></A=
><BR><FONT=20
face=3D"Times New Roman" size=3D3>&gt;<BR>&gt;<BR>&gt; &gt; I have searched=
 all of=20
the archive but nothing close.&nbsp; Can you give me<BR>the<BR>&gt; &gt; ex=
act=20
link from where I can download PG 7.2.3. for my RH7.1 box on Intel<BR>&gt; =
&gt;=20
PIII, as I was trying to google but there are so many downloads that Iam<BR=
>&gt;=20
&gt; confused.<BR>&gt; &gt;<BR>&gt; &gt; Thanks<BR>&gt; &gt;=20
-Uday<BR>&gt;<BR>&gt;<BR>&gt; --<BR>&gt; This message has been scanned for=
=20
viruses and<BR>&gt; dangerous content by MailScanner, and is<BR>&gt; believ=
ed to=20
be clean.</FONT><BR></FONT></DIV></BODY></HTML>

------=_NextPart_000_0037_01C2B0DB.F00E7180--





From tgl@sss.pgh.pa.us Tue Dec  31 17:17:16 2002
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id B2A2A476295
	for <pgsql-interfaces@postgresql.org>;
	Tue, 31 Dec 2002 12:17:16 -0500 (EST)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP id DEDF64758FE
	for <pgsql-interfaces@postgresql.org>;
	Tue, 31 Dec 2002 12:16:36 -0500 (EST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id gBVHGZd0000983;
	Tue, 31 Dec 2002 12:16:35 -0500 (EST)
To: "Uday" <uday@accord.co.in>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: PGLOG problem 
In-reply-to: <003a01c2b0ad$d7599bc0$2664a8c0@uday> 
References: <003a01c2b0ad$d7599bc0$2664a8c0@uday>
Comments: In-reply-to "Uday" <uday@accord.co.in>
	message dated "Tue, 31 Dec 2002 14:50:19 +0530"
Date: Tue, 31 Dec 2002 12:16:35 -0500
Message-ID: <982.1041354995@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200212/86
X-Sequence-Number: 3499

"Uday" <uday@accord.co.in> writes:
> postmaster: error while loading shared libraries: /usr/lib/libreadline.so.4:
> undefined symbol: BC

I'm not sure what "BC" is, but on many platforms libreadline requires
libtermcap.  Do you have that installed?

			regards, tom lane