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

From: John Mitchell <mitchelljj98(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: John Mitchell <mitchelljj98(at)gmail(dot)com>
Subject: What locking mechanism is used for database backup and restore and Master-Slave Replication?
Date: 2010-01-21 13:12:33
Message-ID: fa2ac0581001210512g61f93d99r7464d4c90e787b0e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2010-01-21 13:20:14 Re: What locking mechanism is used for database backup and restore and Master-Slave Replication?
Previous Message Adrian von Bidder 2010-01-21 13:06:38 Re: 64bits or 32 bits on ESX?