Re: Need help on WAL shipping

Yes, that's me and it is for windows.
I enabled archive and copy WAL file, created base backup.

Restored base backup to target, removed files under pg-xlog, copy over archived WAL files, for some reason recovery always look for WAL files from base restore, not those archived WAL files.

------Original Message------
From: Joshua D. Drake
To: steeles(at)gmail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
ReplyTo: jd(at)commandprompt(dot)com
Subject: Re: [GENERAL] Need help on WAL shipping
Sent: Aug 2, 2010 5:07 PM

On Mon, 2010-08-02 at 21:04 +0000, steeles(at)gmail(dot)com wrote:
> Hi, I posted twice and didn't get any response, wonder my post didn't get populated properly.
>
> Again, followed the document on WAL shipping, and couldn't get target to recognize the archive WAL files. It looks for different WAL files.

The post I saw was rather unreadable, I believe you were the one trying
log shipping on Windows correct?

JD

>
> Did I miss any steps?
>
> Thx
> Sent from my BlackBerry device on the Rogers Wireless Network
>

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt

Sent from my BlackBerry device on the Rogers Wireless Network