Pg_dump consistency.

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

 



Hi All

I have a doubt.
let's say i have 100 tables in a database DB.

when i say "pg_dump -d DB"

It dumps the tables one after another.

my question is lets say we have dependent tables.
and at the time of pg_dump, we are bombarding the database tables with lots of data (inserts).

At time 1 (dump of table1 is done)

Table1  
---------
Id1 row1
-----------

Table2  
---------
Id1 rowx1
-----------

At time 2 (dump of table2 is going on)

Table1  
---------
Id1 row1
Id2 row2
-----------

Table2  
---------
Id1 rowx1
Id2 rowx2
-----------


Now in this scenaio
will the dump contains the consistent data.??

Thanks
Srikanth

[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