Re: time-delayed standbys

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема Re: time-delayed standbys
Дата
Msg-id BANLkTikHcD8H=iS=xZCTnyNAYMbDu3Tj1Q@mail.gmail.com
обсуждение исходный текст
Ответ на time-delayed standbys  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: time-delayed standbys  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Tue, Apr 19, 2011 at 9:47 PM, Robert Haas <robertmhaas@gmail.com> wrote:
>
> That is, a standby configured such that replay lags a prescribed
> amount of time behind the master.
>
> This seemed easy to implement, so I did.  Patch (for 9.2, obviously) attached.
>

This crashes when stoping recovery to a target (i tried with a named
restore point and with a poin in time) after executing
pg_xlog_replay_resume(). here is the backtrace. I will try to check
later but i wanted to report it before...

#0  0xb7777537 in raise () from /lib/libc.so.6
#1  0xb777a922 in abort () from /lib/libc.so.6
#2  0x08393a19 in errfinish (dummy=0) at elog.c:513
#3  0x083944ba in elog_finish (elevel=22, fmt=0x83d5221 "wal receiver
still active") at elog.c:1156
#4  0x080f04cb in StartupXLOG () at xlog.c:6691
#5  0x080f2825 in StartupProcessMain () at xlog.c:10050
#6  0x0811468f in AuxiliaryProcessMain (argc=2, argv=0xbfa326a8) at
bootstrap.c:417
#7  0x0827c2ea in StartChildProcess (type=StartupProcess) at postmaster.c:4488
#8  0x08280b85 in PostmasterMain (argc=3, argv=0xa4c17e8) at postmaster.c:1106
#9  0x0821730f in main (argc=3, argv=0xa4c17e8) at main.c:199


--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: pg_upgrade copy_file not needed on Win32
Следующее
От: "David E. Wheeler"
Дата:
Сообщение: Re: Extension Packaging