*Would you mind providing more insights on type of replication that is in use as email states that switch performed from slave to master ?* * * *Initial glance points towards catalog corruptions however would like to understand the replication methodology used here..*
*Thanks & Regards,* *** * *Prashanth Ranjalkar* *Database Consultant & Architect* *Skype:prashanth.ranjalkar* *www.postgresdba.net* On Thu, Apr 11, 2013 at 1:51 PM, X.H.----WANG <82661...@qq.com> wrote: > > I'm sorry,I forgot to attach the log info: > > WARNING: pgstat wait timeout > SELECTWARNING: pgstat wait timeout > SELECTWARNING: corrupted statistics file "pg_stat_tmp/pgstat.stat" > VACUUMWARNING: pgstat wait timeout > > > ------------------ Original ------------------ > *From: * "Vasilis Ventirozos"<v.ventiro...@gmail.com>; > *Date: * Thu, Apr 11, 2013 02:29 PM > *To: * "X.H.----WANG"<82661...@qq.com>; ** > *Cc: * "pgsql-admin"<pgsql-admin@postgresql.org>; ** > *Subject: * Re: [ADMIN] with PostgreSQL 9.1.9,the stats collector process > is not work! > > > > On Thursday, April 11, 2013, X.H.----WANG <82661...@qq.com> wrote: > >> Hello everybody: >> After I switch the slave to the master , I can not get the stats >> information by the below sql and the pg_stat_reset() does not work on >> the New Master, >> And I vacuum by hand,it's still not work! I need some help.Could you >> give me any idea? >> >> the stat sql: >> >> SELECT st.relname, n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd, >> n_live_tup, n_dead_tup, last_vacuum, last_autovacuum, last_analyze, >> last_autoanalyze, vacuum_count, autovacuum_count, analyze_count, >> autoanalyze_count, pg_size_pretty(pg_relation_size(st.relid) + CASE WHEN >> cl.reltoastrelid = 0 THEN 0 ELSE pg_relation_size(cl.reltoastrelid) + >> COALESCE((SELECT SUM(pg_relation_size(indexrelid)) FROM pg_index WHERE >> indrelid=cl.reltoastrelid)::int8, 0) END + COALESCE((SELECT >> SUM(pg_relation_size(indexrelid)) FROM pg_index WHERE >> indrelid=st.relid)::int8, 0)) AS size FROM pg_stat_all_tables st JOIN >> pg_class cl on cl.oid=st.relid WHERE schemaname = 'public' ORDER BY relname; >> >> My environment: >> >> Linux 3.2.1-gentoo-r2 >> postgresql 9.1.9, >> >> the paras: >> "autovacuum";"on" >> "track_counts";"on" >> >> /etc/hosts: >> 127.0.0.1 localhost 192.168.0.22 localhost.localdomain localhost >> >> the postgresql's processes exist: >> >> writer process stats collector process wal writer process autovacuum >> launcher process wal sender process >> >> Thank you for your time! >> Best Regard! >> >> River >> >> >> >> >>
