On Tue, Aug 16, 2011 at 7:34 AM, senthilnathan <senthilnatha...@gmail.com> wrote: > Thanks for your reply. > > What will happen if you issue *checkpoint* at STANDBY. I presume that it > will flush the data to the disk.
Yes. On the standby that is known as a restartpoint. > Will there be any conflict with the master WAL.(like checkpoint location...) No, there is no effect on the master. The restartpoint happens as a background process on the standby, so replay will continue while we restart. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers