Newby Help needed

From: Andrea <arussos(at)comune(dot)modena(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Newby Help needed
Date: 2008-04-04 10:45:34
Message-ID: 47F606CE.3040809@comune.modena.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all, i'm newby to postgresql: really great product.

I'm trying to understand exactly how to set up WAL archiving.
I read the doc ( by the way i'm running postgresql-8.1.11 ): i need some
explanation on how are created and recycled theWAL bacause i cannot
understand, for example, how is filled-up the dir pg_xlog/archive-status.

I noticed that sometimes the same file is present in pg_xlog dir and
also in archive-status dir with the extension .ready. Then, after some
time ( i cannot understand how long, and wehre this parameter, if any,
is written ) it disappear from only archive-status directory...

Some one can help in understanding these ??

Many thanks in advance to any one will post an answer..

--Andrea

Browse pgsql-general by date

  From Date Subject
Next Message Stephane Bortzmeyer 2008-04-04 12:16:53 Re: how to insert values into complex type field
Previous Message Gregory Stark 2008-04-04 10:18:09 Re: is it helpful for the optimiser/planner to add LIMIT 1