Re: WAL log shipping + Streaming replication PG 9.0 questions
| От | Fujii Masao |
|---|---|
| Тема | Re: WAL log shipping + Streaming replication PG 9.0 questions |
| Дата | |
| Msg-id | AANLkTi=DHscwip3JhGOSPBA9H_VcqHHFjdJy5Bomj2Tv@mail.gmail.com обсуждение исходный текст |
| Ответ на | WAL log shipping + Streaming replication PG 9.0 questions (Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>) |
| Ответы |
Re: WAL log shipping + Streaming replication PG 9.0 questions
|
| Список | pgsql-admin |
On Tue, Oct 19, 2010 at 2:48 AM, Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca> wrote: > I have some questions regarding hot standby + streaming replication (PG > 9.0) : what is master/primary server behavior if archive_command fails > due to archive directory off line/unavailable? Unarchived WAL files continue to accumulate in pg_xlog directory while the archive directory is unavailable. Then, if pg_xlog directory is filled up, the PostgreSQL server causes the PANIC error. > How about standby server behavior if restore command fails due to > archive_master directory not available? After restore_command fails, the standby tries to read WAL file from its pg_xlog directory. And, if there is no WAL file to recover in pg_xlog, the standby tries to connect to the master and read the streamed WAL files from the master. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center
В списке pgsql-admin по дате отправления: