From: Richard Huxton <dev@archonet.com>
To: Florian Litot <flitot@besancon.sema.slb.com>
Cc: pgsql-general@postgresql.org
Subject: Re: log file?
Date: Tue, 5 Nov 2002 16:57:08 +0000
Message-ID: <200211051657.08130.dev@archonet.com> (raw)
In-Reply-To: <4.3.2.7.2.20021105171100.00d89ea0@pop.besancon.tt.slb.com>
References: <4.3.2.7.2.20021105121304.022c5100@pop.besancon.tt.slb.com>
<4.3.2.7.2.20021105171100.00d89ea0@pop.besancon.tt.slb.com>
On Tuesday 05 Nov 2002 4:11 pm, you wrote:
> At 12:47 05/11/02, Richard Huxton wrote:
> > > but the problem is it never recycle this file so i have a got a px_log
> > > 2Go how i can resolve this problem?
> > > why it doesn't recycle?
> >
> >According to the log you posted it was being recycled.
> >
> >How many files are there in pg_xlog and what dates do they have?
> >What are the WAL settings in your postgresql.conf file?
> >Do you have any clients that have been running a long time?
> >
> >--
> > Richard Huxton
>
> when this files is recycling?
> because my database is always connecting
> what can i do?
As long as the number of files isn't increasing, all is well. The only reason
old files wouldn't get recycled is if a client might refer to a transaction
held in it. It doesn't matter if you have lots of clients running lots of
queries, the files will still get recycled.
See my previous reply for why you have 66 files.
--
Richard Huxton
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-general@postgresql.org
Cc: dev@archonet.com, flitot@besancon.sema.slb.com
Subject: Re: log file?
In-Reply-To: <200211051657.08130.dev@archonet.com>
* 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