RE: automatic restore point

Поиск
Список
Период
Сортировка
От Yotsunaga, Naoki
Тема RE: automatic restore point
Дата
Msg-id 8E9126CB6CE2CD42962059AB0FBF7B0DBF8BC0@g01jpexmbkw23
обсуждение исходный текст
Ответ на Re: automatic restore point  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: automatic restore point  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
>-----Original Message-----
>From: Michael Paquier [mailto:michael@paquier.xyz] 
>Sent: Wednesday, July 11, 2018 3:34 PM

>Well, if you put in place correct measures from the start you would not have problems.  
>It seems to me that there is no point in implementing something which is a solution for a very narrow case, where the
userhas shot his own foot to begin with. 
 
>Having backups anyway is mandatory by the way, standby replicas are not backups.

I think that the Undo function of AWS and Oracle's Flashback function are to save such users, and it is a function to
preventhuman error.
 
So, how about postgres implementing such a function?
 
Also, as an approach to achieving the goal, I thought about outputting lsn to the server log when a specific command
wasexecuted.
 
 
I do not think the source code of postgres will be complicated when implementing this function.
Do you feel it is too complicated?

-------
Naoki Yotsunaga

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Constraint documentation
Следующее
От: Pierre Ducroquet
Дата:
Сообщение: [PATCH] LLVM tuple deforming improvements