Re: PITR - recovery to a particular transaction

Поиск
Список
Период
Сортировка
От G u i d o B a r o s i o
Тема Re: PITR - recovery to a particular transaction
Дата
Msg-id 20040804165955.ADDB56CB43@tino.sinectis.com.ar
обсуждение исходный текст
Ответ на PITR - recovery to a particular transaction  (Oliver Elphick <olly@lfix.co.uk>)
Ответы Re: PITR - recovery to a particular transaction  (Gaetano Mendola <mendola@bigfoot.com>)
Список pgsql-hackers
8.0 || 7.5??

g:)

> The PITR docs that have just been put up say:
> 
>         But if you want to recover to some previous point in time (say,
>         right before the junior DBA dropped your main transaction
>         table), just specify the required stopping point in
>         recovery.conf. You can specify the stop point either by
>         date/time or by transaction ID. As of this writing only the
>         date/time option is very usable, since there are no tools to
>         help you identify which transaction ID to use.
> 
> How about adding a logging option to put the transaction id on the log
> for every statement that modifies the database?  Would that be a small
> enough change to be allowed into 8.0?
> -- 
> Oliver Elphick                                          olly@lfix.co.uk
> Isle of Wight                              http://www.lfix.co.uk/oliver
> GPG: 1024D/A54310EA  92C8 39E7 280E 3631 3F0E  1EC0 5664 7A2F A543 10EA
>                  ========================================
>      "And not only so, but we glory in tribulations also; 
>       knowing that tribulation worketh patience; And  
>       patience, experience; and experience, hope."          
>                                         Romans 5:3,4 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
>                http://archives.postgresql.org



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

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: PITR - recovery to a particular transaction
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Anybody have an Oracle PL/SQL reference at hand?