Skip site navigation (1) Skip section navigation (2)

Re: problem with WAL files

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: problem with WAL files
Date: 2005-06-30 22:03:46
Message-ID: Pine.LNX.4.63.0506301502340.15741@discord.dyndns.org (view raw or flat)
Thread:
Lists: pgsql-admin
On Thu, 30 Jun 2005, Tom Lane wrote:

> Apparently it wasn't able to get the 00000001000000000000000B segment
> from the archive either.  The displayed restore_command looks a bit
> bogus to me: too many \'s.  Maybe you need to correct that?

Tom,

When I tested with our system, it would not attempt to retrieve that first WAL 
via the restore command.  All the ones after that it was happy to do it for, 
but if that one did not exist, it told me to get lost.  That was on 8.0.3.  I 
did not test any other versions.

Putting it in the pg_xlog dir made everything go smoothly though.

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

In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2005-06-30 22:31:09
Subject: Re: problem with WAL files
Previous:From: Tom LaneDate: 2005-06-30 21:12:24
Subject: Re: problem with WAL files

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group