Thread: Need help on WAL shipping
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
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
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
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