Re: Online base backup from the hot-standby
| От | Fujii Masao |
|---|---|
| Тема | Re: Online base backup from the hot-standby |
| Дата | |
| Msg-id | CAHGQGwGHUV4C99CC1xddcStJNQ9gb-tHg5J7+o1q+gAabt27Vw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Online base backup from the hot-standby (Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>) |
| Ответы |
Re: Online base backup from the hot-standby
|
| Список | pgsql-hackers |
2011/7/4 Jun Ishiduka <ishizuka.jun@po.ntts.co.jp>: > >> When the standby restarts after it crashes during recovery, it always >> checks whether recovery has reached the backup end location by >> using minRecoveryPoint even though the standby doesn't start from >> the backup. This looks odd. > > Certainly. > > But, in this case, the state before recovery starts is lost. > Therefore, postgres can not see that the backup got from whether > standby server or master. > > What should? > Should use pg_control? > Ex. > * Add 'Where to get backup' to pg_control. (default 'none') > * When recovery starts, it checks it whether 'none'. > * When minRecoveryPoint equals 0/0, change 'master'. > * When minRecoveryPoint do not equals 0/0, change 'slave'. > * When it reached the end of recovery, change 'none' . What about using backupStartPoint to check whether this recovery started from the backup or not? Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center
В списке pgsql-hackers по дате отправления: