What locking mechanism is used for database backup and restore and Master-Slave Replication?

Поиск
Список
Период
Сортировка
От John Mitchell
Тема What locking mechanism is used for database backup and restore and Master-Slave Replication?
Дата
Msg-id fa2ac0581001210512g61f93d99r7464d4c90e787b0e@mail.gmail.com
обсуждение исходный текст
Ответы Re: What locking mechanism is used for database backup and restore and Master-Slave Replication?  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Список pgsql-general
Дерево обсуждения
Hi,

In reading the documentation it states that the SQL dump backup does not block other operations on the database while it is working.

I presume that while a restore is occurring that no reads or updates are allowed against the restored database.

What locking mechanism is used for Master-Slave Replication?

Thanks,

John J. Mitchell

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

Предыдущее
От: Adrian von Bidder
Дата:
Сообщение: Re: 64bits or 32 bits on ESX?
Следующее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: Re: What locking mechanism is used for database backup and restore and Master-Slave Replication?