Re: Proposal: Snapshot cloning

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Proposal: Snapshot cloning
Дата
Msg-id 25068.1169829638@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Proposal: Snapshot cloning  (Hannu Krosing <hannu@skype.net>)
Список pgsql-hackers
Hannu Krosing <hannu@skype.net> writes:
> Ühel kenal päeval, N, 2007-01-25 kell 22:19, kirjutas Jan Wieck:
>> The cloning process needs to make sure that the clone_snapshot() call is 
>> made from the same DB user in the same database as corresponding 
>> publish_snapshot() call was done. 

> Why ? Snapshot is universal and same for whole db instance, so why limit
> it to same user/database ?

Yeah.  Use-case: pg_dumpall could guarantee that it produces consistent
snapshots across multiple databases.  (Not sure I actually want that,
but it's at least arguably useful to someone.)

I think you would want to mark a snapshot with an owner, but that would
be for the purpose of restricting who could take it down, not who could
copy it.
        regards, tom lane


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

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: Implied Functional index use (redux)
Следующее
От: "Pavan Deolasee"
Дата:
Сообщение: Re: Piggybacking vacuum I/O