Re: Fwd: [GENERAL] 9.1.3: launching streaming replication

Поиск
Список
Период
Сортировка
От Michael Nolan
Тема Re: Fwd: [GENERAL] 9.1.3: launching streaming replication
Дата
Msg-id CAOzAqu+cKdRkEv=ynczgh9QagXRYQV7N31P0ThXrXPtvm3wTXA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Fwd: [GENERAL] 9.1.3: launching streaming replication  (Greg Smith <greg@2ndQuadrant.com>)
Список pgsql-docs


On Tue, Apr 3, 2012 at 7:30 PM, Greg Smith <greg@2ndquadrant.com> wrote:
 
Mike already fixed the category problem himself.  I just updated http://wiki.postgresql.org/wiki/Streaming_Replication so that it suggests users visit the official docs and tutorial on the wiki, since we can't just make Google unlike that page easily.

Greg, there's sort of an inconsistency between the developer-oriented streaming replication page and the tutorial.

The streaming replication page says to copy the entire data directory, which would include the WAL logs in the pg_xlog directory.  The 5 minute version in the binary replication tutorial skips that directory, the longer one copies it separately, after the backup is complete, so that the slave can perform any committed changes as part of syncing up with the master. 

I assume that there is no harm in copying the pg_xlog directory in the 5 minute version, and it was left out as a time-saver.  However, if the master fails and the slave has to take over, wouldn't it need the pg_xlog directory?  If it hasn't been created, could that cause problems or would the backend know to create it? 
--
Mike Nolan 

В списке pgsql-docs по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Fwd: [GENERAL] 9.1.3: launching streaming replication
Следующее
От: Thom Brown
Дата:
Сообщение: ODBCng