Postgres Pro
Downloads
Home   >   mailing lists

What locking mechanism is used for database backup and restore and Master-Slave Replication? - Mailing list pgsql-general

From John Mitchell
Subject What locking mechanism is used for database backup and restore and Master-Slave Replication?
Date
Msg-id fa2ac0581001210512g61f93d99r7464d4c90e787b0e@mail.gmail.com
Whole thread Raw
Responses Re: What locking mechanism is used for database backup and restore and Master-Slave Replication?  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Adrian von Bidder
Date:
Subject: Re: 64bits or 32 bits on ESX?
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: What locking mechanism is used for database backup and restore and Master-Slave Replication?