Re: backing up without lock ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, 2005-07-18 at 12:25, FM wrote:
> Hello,
> Is it possible to backup postgresql databases  without locking tables.

Yes and no.

No, it's actually possible to backup postgresql without a lock.

However, it's an access shared lock, so it's not a blocking lock.

Also, the backup is coherent for a whole database at the point in time
the backup was initiated.

http://www.postgresql.org/docs/8.0/static/app-pgdump.html


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux