[GENERAL] Broken WAL recovery, resetting to base timeline

2009-10-08 Thread David Jantzen
Hi All, While recovering a database, we encountered a file permissions problem on new WAL segments that caused recovery with pg_standby to exit prematurely. Now the database is in a new timeline. What we need to do (I think) is reset the database timeline to that of the base copy and resume r

[GENERAL] Reversing flow of WAL shipping

2009-10-21 Thread David Jantzen
Hey Folks, I want to run a warm standby scenario by you. I'm pretty sure it'll work, but it's a very large database so even the slightest mistake can mean a major setback. Scenario: Server A is the provider node, shipping WAL files to Server B. Server B is destined to become the provider