On Thu, Jan 26, 2017 at 8:45 PM, Peter Eisentraut <peter.eisentraut@2ndquadrant.com> wrote: > On 1/24/17 3:26 AM, Mithun Cy wrote: >> In my code by default, we only dump at shutdown time. If we want to >> dump at regular interval then we need to set the GUC >> pg_autoprewarm.buff_dump_interval to > 0. > > Just a thought with an additional use case: If I want to set up a > standby for offloading queries, could I take the dump file from the > primary or another existing standby, copy it to the new standby, and > have it be warmed up to the state of the other instance from that? > > In my experience, that kind of use is just as interesting as preserving > the buffers across a restart. >
An interesting use case. I am not sure if somebody has tried that way but it appears to me that the current proposed patch should work for this use case.
Even I feel this should work.
In that case, we could add the file location parameter. By default it would store in the cluster directory else in the location provided. We can update this parameter in standby for it to access the file.