Hi,
we have a postgresql 9.0, I setup collectd to gather some information.
It frequently ask the database about the bgwriter state by requesting
select * from pg_stat_bgwriter (among other stats).
It seems that this requets takes 6-7s to answer and in the log we got
pgstat timeout
Note: The
I think that you need to create a new base backup from the new master to
make the old master a standby server. I usually do this using rsync, so
that it takes as fast as possible, but you could also use a tool like
http://www.repmgr.org/
Regards,
Strahinja
On Mon, May 13, 2013 at 9:23 AM,