another wal archive question

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: SF Postgres <sfpug(at)postgresql(dot)org>
Subject: another wal archive question
Date: 2005-06-23 16:39:38
Message-ID: Pine.LNX.4.63.0506230938350.21285@discord.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: sfpug

When reading the docs on recovery.conf, I noticed this:

WAL segments that cannot be found in the archive will be sought in pg_xlog/;
this allows use of recent un-archived segments. However segments that are
available from the archive will be used in preference to files in pg_xlog/.
The system will not overwrite the existing contents of pg_xlog/ when
retrieving archived files.

If the system will use the files in the archive in preference to the ones in
pg_xlog, how can this actually happen if it will not overwrite the contents of
pg_xlog?

--
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954

Responses

Browse sfpug by date

  From Date Subject
Next Message Jeff Frost 2005-06-23 17:04:32 Re: another wal archive question
Previous Message postgresql.org 2005-06-23 08:14:40 Re: XMLSchema