On Sat, 2008-12-06 at 17:55 +0900, Fujii Masao wrote: > Yeah, it's my imagination about the real situation after 8.4 release, > especially I considered about the future conjugal life of Synch Rep and > Hot Standby ;) Waiting to redo until the file fills might lead to marital > breakdown.
You're obviously working with some comedians now. ;-) > > Could we start with pictures and some descriptions first, so we know > > we're on the right track? I foresee no coding issues. > > > > My understanding is that we start with a normal log shipping > > architecture, then we switch into continuous recovery mode. So we do use > > pg_standby at beginning, but then it gets turned off. > > Yes, I also understand so. Updated sequence pictures are on wiki > as per usual. Please see P3, 4. > http://wiki.postgresql.org/wiki/NTT%27s_Development_Projects#Detailed_Design p.6 looks good. But what is p.7? It's even more complex than the original. Forgive me, but I don't understand that. Can you explain? What is the procedure if the standby shuts down, for example if we wish to restart server to change a parameter? Or to reboot the system it is on. Does the primary switch back to writing files to archive? -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers