Thread: Need help on WAL shipping

Need help on WAL shipping

From
steeles@gmail.com
Date:
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
differentWAL files. 

Did I miss any steps?

Thx
Sent from my BlackBerry device on the Rogers Wireless Network

Re: Need help on WAL shipping

From
"Joshua D. Drake"
Date:
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
fordifferent 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

Re: Need help on WAL shipping

From
steeles@gmail.com
Date:
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
alwayslook 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
fordifferent 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

Re: Need help on WAL shipping

From
"Joshua D. Drake"
Date:
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
fordifferent 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