Content-Type: text/plain;
  charset="iso-8859-1"
From: Richard Huxton <dev@archonet.com>
Organization: Archonet Ltd
To: Florian Litot <flitot@besancon.sema.slb.com>
Subject: Re: log file?
Date: Tue, 5 Nov 2002 16:57:08 +0000
User-Agent: KMail/1.4.3
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>
In-Reply-To: <4.3.2.7.2.20021105171100.00d89ea0@pop.besancon.tt.slb.com>
Cc: pgsql-general@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200211051657.08130.dev@archonet.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 reas=
on=20
old files wouldn't get recycled is if a client might refer to a transaction=
=20
held in it. It doesn't matter if you have lots of clients running lots of=
=20
queries, the files will still get recycled.

See my previous reply for why you have 66 files.

--=20
  Richard Huxton