Thread: PGLOG problem

PGLOG problem

From
"Uday"
Date:
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 system could not access the database and I had to restore the original.
 
Please all help will be welcomed before the system goes down.  Currently the size of the "pg_log" is approx. 300MB.  So it is pretty urgent.
 
Thanks in advance
 
-Uday

Re: PGLOG problem

From
Tom Lane
Date:
"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


Re: PGLOG problem

From
"Uday"
Date:
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
>




Re: PGLOG problem

From
Adam Witney
Date:
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.



Re: PGLOG problem

From
"Uday"
Date:
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.

Re: PGLOG problem

From
Tom Lane
Date:
"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