Need help on WAL shipping

On Mon, 2010-08-02 at 21:04 +0000, steeles@gmail.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

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@gmail.com
Cc: pgsql-general@postgresql.org
ReplyTo: jd@commandprompt.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@gmail.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