Search Postgresql Archives

Reversing flow of WAL shipping

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 node (newer hardware), and has a  
sibling Server C that will be the warm standby.

Here's the question: when I turn Server B into the production/provider  
node, it's going to switch into the next timeline.  If I then attempt  
to put Server A (or Server C) into recovery mode, will it switch to  
the new current timeline, or complain about being in the older  
timeline?  Do I have to take another full backup of Server B after  
it's become the production/provider node?

Thanks,
David


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux