Hi all,
A few days back, I faced a problem where I pg_start_backup('label') was hang in the server forever.
I stopped the process and then used pg_start_backup('label',true) and it worked.
Now I am trying to investigate why I need to use true as second parameter and read the doc
"There is an optional second parameter of type boolean. If true, it specifies executing pg_start_backup as quickly as possible. This forces an immediate checkpoint which will cause a spike in I/O operations, slowing any concurrently executing queries."
I tried to regenerate the scenario where pg_start_backup('label') hanged and I failed.
Any idea, how can I regenerate that issue to investigate.
I am using Postgresql 9.2.
Thanks.