pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedPGLOG problem
6+ messages / 3 participants
[nested] [flat]
* PGLOG problem
@ 2002-10-21 05:27 Uday <uday@accord.co.in>
0 siblings, 1 reply; 6+ messages in thread
From: Uday @ 2002-10-21 05:27 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PGLOG problem
@ 2002-10-21 13:09 Tom Lane <tgl@sss.pgh.pa.us>
parent: Uday <uday@accord.co.in>
0 siblings, 1 reply; 6+ messages in thread
From: Tom Lane @ 2002-10-21 13:09 UTC (permalink / raw)
To: Uday <uday@accord.co.in>; +Cc: pgsql-interfaces
"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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PGLOG problem
@ 2002-11-29 12:12 Adam Witney <awitney@sghms.ac.uk>
parent: Uday <uday@accord.co.in>
0 siblings, 0 replies; 6+ messages in thread
From: Adam Witney @ 2002-11-29 12:12 UTC (permalink / raw)
To: Uday <uday@accord.co.in>; +Cc: pgsql-interfaces
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PGLOG problem
@ 2002-11-29 12:15 Uday <uday@accord.co.in>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: Uday @ 2002-11-29 12:15 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-interfaces
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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PGLOG problem
@ 2002-12-31 09:20 Uday <uday@accord.co.in>
0 siblings, 1 reply; 6+ messages in thread
From: Uday @ 2002-12-31 09:20 UTC (permalink / raw)
To: pgsql-interfaces
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PGLOG problem
@ 2002-12-31 17:16 Tom Lane <tgl@sss.pgh.pa.us>
parent: Uday <uday@accord.co.in>
0 siblings, 0 replies; 6+ messages in thread
From: Tom Lane @ 2002-12-31 17:16 UTC (permalink / raw)
To: Uday <uday@accord.co.in>; +Cc: pgsql-interfaces
"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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2002-12-31 17:16 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-10-21 05:27 PGLOG problem Uday <uday@accord.co.in>
2002-10-21 13:09 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-11-29 12:15 ` Uday <uday@accord.co.in>
2002-11-29 12:12 ` Adam Witney <awitney@sghms.ac.uk>
2002-12-31 09:20 Re: PGLOG problem Uday <uday@accord.co.in>
2002-12-31 17:16 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox