Postgres Pro
Downloads
Home   >   mailing lists

pg_start_backup('label',true) why do I need 2nd parameter? - Mailing list pgsql-general

From AI Rumman
Subject pg_start_backup('label',true) why do I need 2nd parameter?
Date
Msg-id CAGoODpcTL4XybXdJ1GVg=+xyR+M5ujbJ7Wqojp7hEhjt7m3rCQ@mail.gmail.com
Whole thread Raw
Responses Re: pg_start_backup('label',true) why do I need 2nd parameter?
Re: pg_start_backup('label',true) why do I need 2nd parameter?
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: sparikh
Date:
Subject: Clone database using rsync?
Next
From: Jeff Janes
Date:
Subject: Re: Clone database using rsync?