Обсуждение: PGLOG problem
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
"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
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 >
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.
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.
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.
"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