From: | Jeff Frost <jeff(at)frostconsultingllc(dot)com> |
---|---|
To: | SF Postgres <sfpug(at)postgresql(dot)org> |
Subject: | Re: another wal archive question |
Date: | 2005-06-23 17:04:32 |
Message-ID: | Pine.LNX.4.63.0506231003290.21285@discord.dyndns.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | sfpug |
I also noticed that if there is not at least one wal archive available in the
archive or the pg_xlog dir, the restore errors out and exits. So the base
backup is really not complete without at least one wal archive following it.
On Thu, 23 Jun 2005, Jeff Frost wrote:
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2005-06-23 17:34:44 | Topics for Next Meeting |
Previous Message | Jeff Frost | 2005-06-23 16:39:38 | another wal archive question |