Re: pg_dump and not MVCC-safe commands

Поиск
Список
Период
Сортировка
От PetSerAl
Тема Re: pg_dump and not MVCC-safe commands
Дата
Msg-id CAKygsHS2rKkzRFh-SygCjR-TGLhpbWxci4Ms5BxoJ9KJ5DXhxA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_dump and not MVCC-safe commands  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: pg_dump and not MVCC-safe commands
Список pgsql-general
> However, it would be the very same
> database state that any other query would see at that time.
Other queries can use different techniques to prevent this. For
example, lock tables before snapshot, as recommended in documentation.
I understand, that pg_dump can not use that, as it need snapshot to
enumerate tables to lock.

> then you brought
> that on your own head by using TRUNCATE concurrently with other
> operations.
People, who admins database servers, are not always the same people,
who write application/queries. That means, if you know nothing about
application, you can not guarantee, if live database backup would be
consistent. Basically, you need application cooperation to make
consistent live database backup.



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump and not MVCC-safe commands
Следующее
От: Christophe Pettus
Дата:
Сообщение: Re: pg_dump and not MVCC-safe commands