Обсуждение: Re: with PostgreSQL 9.1.9,the stats collector process is not work!
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.ventirozos@gmail.com>;
Date: Thu, Apr 11, 2013 02:29 PM
To: "X.H.----WANG"<82661063@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 <82661063@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-r2postgresql 9.1.9,the paras:"autovacuum";"on""track_counts";"on"/etc/hosts:127.0.0.1 localhost 192.168.0.22 localhost.localdomain localhostthe postgresql's processes exist:writer process stats collector process wal writer process autovacuum launcher process wal sender processThank you for your time!Best Regard!River
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
On Thu, Apr 11, 2013 at 1:51 PM, X.H.----WANG <82661063@qq.com> wrote:
I'm sorry,I forgot to attach the log info:WARNING: pgstat wait timeoutSELECTWARNING: pgstat wait timeoutSELECTWARNING: corrupted statistics file "pg_stat_tmp/pgstat.stat"VACUUMWARNING: pgstat wait timeout------------------ Original ------------------From: "Vasilis Ventirozos"<v.ventirozos@gmail.com>;Date: Thu, Apr 11, 2013 02:29 PMTo: "X.H.----WANG"<82661063@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 <82661063@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-r2postgresql 9.1.9,the paras:"autovacuum";"on""track_counts";"on"/etc/hosts:127.0.0.1 localhost 192.168.0.22 localhost.localdomain localhostthe postgresql's processes exist:writer process stats collector process wal writer process autovacuum launcher process wal sender processThank you for your time!Best Regard!River