Search Postgresql Archives

question about pg_dump

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

 



Hi everyone,

 

I have a question about pg_dump backups.  Will changes made in the database made during a pg_dump operation be reflected in the dumped datafile?  Or is the data the exact dataset that was in the database as of the start of the backup?

 

From what I understand of the documentation, any changes made during the backup would NOT be in the dumped datafile.   That is very important for a monthend process where I need consistent data as of exactly the time the dump starts, which is why I’m confirming that is indeed the case.

 

Thanks,

 

Scot Kreienkamp

skreien@xxxxxxxxxxxx

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux