From: Uday <uday@accord.co.in>
To: pgsql-interfaces@postgresql.org
Subject: PGLOG problem
Date: Mon, 21 Oct 2002 10:57:46 +0530
Message-ID: <006c01c278c2$9bbdf020$2664a8c0@uday> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: uday@accord.co.in
Subject: Re: PGLOG problem
In-Reply-To: <006c01c278c2$9bbdf020$2664a8c0@uday>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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