| From: | Florian Litot <flitot(at)besancon(dot)sema(dot)slb(dot)com> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: log file? |
| Date: | 2002-11-05 16:11:48 |
| Message-ID: | 4.3.2.7.2.20021105171100.00d89ea0@pop.besancon.tt.slb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
At 12:47 05/11/02, Richard Huxton wrote:
>On Tuesday 05 Nov 2002 11:14 am, Florian Litot wrote:
> > At 11:47 05/11/02, Richard Huxton wrote:
> > >PG writes all transactions to disk before actually making changes so that
> > > you can recover in the event of a crash. It splits this transaction log
> > > into chunks and recycles them when all the transactions it refers to are
> > > no longer of interest.
> >
> > 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2002-11-05 16:55:27 | Re: [SQL] Copying a rowtype variable. |
| Previous Message | hr | 2002-11-05 15:59:03 | Why does postgres install try to use cc instead of gcc when compiling tcl ? |